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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
rfwjr64
Frequent Visitor

Dividing

Hello, I am trying to divide a subset of values in one column by the total of the same column.   What I am trying to determine is how many records have an EAU$ of less than $2000 and divide that number by the total number of EAU$ records.  Because some records are duplicates, I would like to find the distinct count for both the under $2k and the overall.   I have a column labeled 'Total EAU$.  I want divide the distinct count of all EAU$ under $2000 by the distinct count of all of the EAU$.

 

I would like to show the two values in a pie chart to demonstrate how many under $2k records are a part of the total records.

 

I don't have an example of what I am doing, unfortunately. 

 

Any help or guidance would be greatly appreciated. 

1 ACCEPTED SOLUTION
Pragati11
Super User
Super User

Hello @rfwjr64 ,

You can create a measure as follows:

calcMeasure - DIVIDE(
CALCULATE(DISTINCTCOUNT(tablename[EAU$]), tablename[EAU$] < 2000),
DISTINCTCOUNT(table name[EAU$]), 0)

Use the table name and column name in the previous DAX expression.

Thank you

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@rfwjr64 , Try a new measure like

divide(calculate(distinctcount(Table[Column), filter(Table, Table[EAU]<2000)),distinctcount(Table[Column))

darentengmfs
Post Prodigy
Post Prodigy

Hi @rfwjr64 

 

The way I would approach this is creating a new column: $ Group = IF([Total EAU$] >2000, "More than $2,000","$2,000 or Less")

 

Then, put a pie chart in your report, under the Values field, put in the distinct ID you have for each row, e.g. SalesID and change the Count to Count Distinct, and put [$ Group] in the legends.

Pragati11
Super User
Super User

Hello @rfwjr64 ,

You can create a measure as follows:

calcMeasure - DIVIDE(
CALCULATE(DISTINCTCOUNT(tablename[EAU$]), tablename[EAU$] < 2000),
DISTINCTCOUNT(table name[EAU$]), 0)

Use the table name and column name in the previous DAX expression.

Thank you

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

This does help. Now I can move on. Thank very much.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors