Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I'm trying to create a count of the Status field that I have shown below for each category: Under Construction, Presale, Complete, etc. Each is displayed 6 times in my data, so my measure is currently counting it 6 times when I create my Count measure. How can I get it to only count each row only once? Or can I get the measure to divide by 6 afterwards?
Here's my measure:
Hi,
You have not shared anough information. Create a Matrix visual. Drag Category to the row labels and Status to the column labels. Create a slicer of month from the Calendar Table and select any one month. Write this measure
=COUNTROWS(Data)
Hope this helps.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.