Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
77 | |
74 | |
57 | |
40 | |
33 |
User | Count |
---|---|
70 | |
63 | |
57 | |
49 | |
46 |