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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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