Calculate difference between value and total value

[Matt78]

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

BR

Matt

[Anonymous · Accepted solution]

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.

[lbendlin]

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

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/1447...