cancel
Showing results 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

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

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

Proud to be a Super User!!

4 REPLIES 4
Super User

@rfwjr64 , Try a new measure like

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

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.

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

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

Proud to be a Super User!!

Frequent Visitor

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

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

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

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors