Forum Discussion

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
3 years ago
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....
  • Justas4478's avatar
    Justas4478
    3 years ago

    I found the change to the measure that solved the problem.

    Voids99p = CALCULATE(COUNTROWS(filter(Actuals,[Voids Value]=0.99)))

ThomasWeppler's avatar
ThomasWeppler
Icon for Impactful Individual rankImpactful Individual
3 years ago

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).

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
3 years ago

I found the change to the measure that solved the problem.

Voids99p = CALCULATE(COUNTROWS(filter(Actuals,[Voids Value]=0.99)))