- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Field Parameters, Dynamic IsInScope
Hello everyone
I made a simple model to make my question clearer. I have two dimensions, Product & Customer and a fact table Sales.
I made a SalesParameter table, which is a field parameter with the two dimension ID's ProductID and CustomerID, renamed as Product and Customer.
I want to use this parameter as rows in a matrix and next to the current level i want the description of the current dimension. For this i created the measure description.
The picture below shows the default case which works fine.
But when the user wants to see the customer first, by clicking the Customer in the field parameter and then the Product, then it doesn't work.
Is there a way to achieve it that the description it doesn't matter in which order I select the field parameter?
Any help is greatly appreciated.
Thanks
Cyrill
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI @CyrillS,
The switch true structures can store multiple conditions and correspond calculations.
AFAIK, it not suitable to use if they are multiple conditions can be match with these conditions and it only triggered the first matched condition.(from top to bottom)
If you want to show multiple conditions, I'd like to suggest use if statement to check these scenarios and stored these results to the variables and concatenate them to get merged results.
Regards,
Xiaoxin Sheng
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello, @Anonymous
I'm trying to solve the same problem, but I haven't succeeded yet. I tried to do as you said, but from what I saw ISINSCOPE is cumulative. Any tips on how to do it?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI @CyrillS,
The switch true structures can store multiple conditions and correspond calculations.
AFAIK, it not suitable to use if they are multiple conditions can be match with these conditions and it only triggered the first matched condition.(from top to bottom)
If you want to show multiple conditions, I'd like to suggest use if statement to check these scenarios and stored these results to the variables and concatenate them to get merged results.
Regards,
Xiaoxin Sheng

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
11 | |
6 | |
4 | |
2 | |
2 |
User | Count |
---|---|
4 | |
4 | |
3 | |
3 | |
3 |