Calculated Column in PowerBI With Filters

0
votes

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

1
powerbidaxpowerbi-desktop

1 Answers

1
votes

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.