Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
CollabTechie
Frequent Visitor

Percentage measure from other measure

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 

1 ACCEPTED SOLUTION
edhans
Super User
Super User

New Measure = DIVIDE([UniqueFlowUsers],25000,0)


Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

3 REPLIES 3
edhans
Super User
Super User

New Measure = DIVIDE([UniqueFlowUsers],25000,0)


Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Hi @edhans , that worked. Thank you!

Great. 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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.