Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello PBI community! I was wondering how I can count a distinct value on multiples column at the same time. As In the example below, I need a measure to count how many zeros (total) there are on columns, 1,2 3 (the answer should be 4):
Thnaks!
Solved! Go to Solution.
Not sure if i missed to understand, but if you need to add all the count of zeros, you can write this
Hi,
In the Query Editor, right click on the first column's heading and select "Unpivot Other Columns". Write this measure
Count = calculate(countrows(Data),Data[Value]=0)
Hope this helps.
Thank you Ashish, I wanted to avoid this step of unpivoting the columns.. Deevaker's solution below worked better for me. Thanks for replying.
You are welcome.
Not sure if i missed to understand, but if you need to add all the count of zeros, you can write this
Hi Deevaker, it worked perfectly! many thanks!
Yes you can do tyhis directly. I did not find a better solution to do it
Hi
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |