Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I'm using measures ONLY and don't have access to the dataset because my data is live connection. Basically for all the 4's, I want them to be 1. How do I count them indivudally and not group them if they have the same value in the first column?
Solved! Go to Solution.
You cant replace values from a measure , you need to make a new measure with conditions if you want the 1 count included just add [count] >=1 isntead of only the > or change the whole measure from the start to just state your conditions and return 1 else blank
Why not just make a condition instead of using count? Like if criteria meets your conditions then return 1 else 0
Like using the IF function on the measure? I need the replace the value of the count if it meets the condition that it is greater than 1. Can I replace the value of the count (4 --> 1)?
I mean yes you could say
If([your count measure] >0 , 1)
Thanks for your reply. I've tried that but it doesn't necessary replace the value of the count. Instead, it just attaches a column to my table visualization. How do I replace the count value?
You cant replace values from a measure , you need to make a new measure with conditions if you want the 1 count included just add [count] >=1 isntead of only the > or change the whole measure from the start to just state your conditions and return 1 else blank
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.