Forum Discussion
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...
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.
hi, if you need comprehensive help you really need to provide adequate sample data in text form. one can't posssibly consider aall scenarios and you have given limited information.
the quality of the solutions is based on the information given, in data there are so many nuances so being explicit with the information will = a good solution.
also what makes up those measures, is there column data you can provide with the measure code, please provide appropriate dummy data in text form if you can't provide the real thing.
thanks!
