Forum Discussion
Solved
Adding measures based on value
I have a few different tables: Fake Doc 1, Fake Doc 2, Fake Doc 3. These all have some values in it. I've created three different risk measures for each of the tables - so Doc 1 Risk, Doc 2 Risk, Doc...
I wasn't able to figure it out in Power BI so I instead calculated risk on the excel sheet first and then summed it using a measure with something like this:
CALCULATE(COUNTA('Doc 1'[]),FILTER('Documents', Documents[Doc Risk]==3))
I wasn't able to figure it out in Power BI so I instead calculated risk on the excel sheet first and then summed it using a measure with something like this:
CALCULATE(COUNTA('Doc 1'[]),FILTER('Documents', Documents[Doc Risk]==3))