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.
Hi Community,
I have a distinct measure to pull back unique users but I need to create another measure that uses this value and provides me with the distinct value as a percentage of 25,000. It will always be 25,000
Current measure that works fine
UniqueFlowUsers = COUNTROWS(DISTINCT(Flows[Owner]))
Any help would be much appreciated
Thanks,
CT
Solved! Go to Solution.
New Measure = DIVIDE([UniqueFlowUsers],25000,0)
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingNew Measure = DIVIDE([UniqueFlowUsers],25000,0)
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingGreat. The final ,0 really isn't necessary in this case. It is the alternate answer if the denominator is 0 so you don't get an error, but in your particular case, the denominator is hardcoded at 25,000, so it will never happen in this measure, but it is good practice to get in the habbit of supplying the alternate answer for other measures.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering 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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |