Forum Discussion

Justas4478's avatar
Justas4478
Post 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....
Need Help
  • 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)))

Justas4478's avatar
Justas4478
Post Prodigy
3 years ago

I have solution that almost works. 

Voids99p = CALCULATE(COUNT('Product'[SKU Number]),filter(Actuals,[Voids Value]=0.99))

The problem is that when i count based on SKU number(Product number) when there are multiple voids of the same product in a day it counts it as one since all same products have same SKU number. I cant see how else I can change measure so it would count same product voids not as single void.

ThomasWeppler's avatar
ThomasWeppler
Impactful 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
    Post Prodigy
    3 years ago

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

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