topic Calculate difference between value and total value in DAX Commands and Tips

Calculate difference between value and total value

Matt78 — Wed, 14 Aug 2024 08:58:14 GMT

Hi all,

I would like to have DAX that measures customer group sales index only.

For example here I have sales indexes of customer groups and customers related to them. If I filter a single customers, then index of a customer group filters also. I would like to view what was customer group index while I filter a single customer.

I don't use matrix to view customer group index but a different visual..

Matt

Re: Calculate difference between value and total value

lbendlin — Wed, 14 Aug 2024 19:26:36 GMT

Most likely you are looking for REMOVEFILTERS

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Calculate difference between value and total value

Anonymous — Thu, 15 Aug 2024 07:13:13 GMT

Hi, Matt78

thanks for lbendlin's concern about this issue.

Since you didn't provide a dataset for testing, I assumed some data for testing and hope it helps:

You can then create a Measure:

SelectedCustomerGroup = CALCULATE ( VALUES ( 'Sales'[CustomerGroup] ), FILTER ( 'Sales', 'Sales'[Customer] = SELECTEDVALUE ( 'Sales'[Customer] ) ) )

Then add a Slicer visual and a Table visual. Here is the test result:

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.