CODEWITHSUNDEEP
powerbidaxpowerbi-desktop
ptfaferreira
ptfaferreira

Reputation: 592

Calculated Column in PowerBI With Filters

I have a problem to solve similar to the example in the image below. I have the values of Column 1, 2 and 3, and want to get the calculated values exampled in Column 4. These are the number of times that the same number of Column 3 appears for different combinations of values from Column 1 and 2. Thanks in advance for any help!

enter image description here

Upvotes: 0

Views: 4433

Answers (1)

WimV
WimV

Reputation: 1005

If your table has as name 'table1', then the following dax statement will calculate column4.

Column4 = CALCULATE(countrows(Table1);filter(Table1;Table1[Column3]= EARLIER(Table1[Column3])))

Keep in mind that based on regional settings, you have to replace the ; with , in the example provided.

Upvotes: 1

Related Questions