Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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
Solved! Go to 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.
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.
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...
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
11 | |
9 | |
8 | |
8 |