Forum Discussion
Oros
Post Prodigy
Post ProdigyCOUNT 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...
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.
Ashish_Mathur
Super User
Super UserHi,
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.
OrosPost Prodigy
Post Prodigy- Ashish_Mathur
You are welcome.