Forum Discussion
Solved
Counting values for measure
Hi I am trying to create the measure that count number of voids where void value is = 0.99p. However [Voids Volume] and [Voids Value] are measures so calculate function does not want to work....
I found the change to the measure that solved the problem.
Voids99p = CALCULATE(COUNTROWS(filter(Actuals,[Voids Value]=0.99)))
Maybe you have to choose the count option instead of the count (distinct) option.
Just go to build visula in the right side and change what you have selected from count to count (distinct).
I found the change to the measure that solved the problem.
Voids99p = CALCULATE(COUNTROWS(filter(Actuals,[Voids Value]=0.99)))