cancel
Showing results for
Did you mean:

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

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
Super User
``New Measure = DIVIDE([UniqueFlowUsers],25000,0)``

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
3 REPLIES 3
Super User
``New Measure = DIVIDE([UniqueFlowUsers],25000,0)``

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
Frequent Visitor

Hi @edhans , that worked. Thank you!

Super User

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

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors