Forum Discussion

Post Prodigy

2 years ago

Solved

COUNT rows with filter

Hello, How do you create a measure to COUNT many rows have zeros (in the VARIANCE column), but excluding the zero IF INVENTORY=0 and COUNTED=0 In the example below, the measure should o...

Need Help

Ashish_Mathur
2 years ago
Hi,

Assuming Inventory, Counted and Variance are measures that you have written, write this measure

Measure = countrows(filter(Values(Data[Product]),[Inventory]<>0&&[Counted]<>0&&[Valiance]=0))

Hope this helps.