CODEWITHSUNDEEP
powerbi
Cookie
Cookie

Reputation: 63

how can I summarize occurence from another table in a pbi table

I have a full list of events in tableA in a pbi report, created tableB with a unique distinct list of events from tableA, how can I create a new column in tableB to return count the number of occurrences from tableA for each of the distinct events in tableB?

Upvotes: 0

Views: 51

Answers (1)

smpa01
smpa01

Reputation: 4282

Column=CALCULATE ( COUNTX ( FILTER ( 'tblA', 'tblA'[Events] = MAX ( tblB[Events] ) ), 'tblA'[Events] ) )

Upvotes: 1

Related Questions