Reply
CyrillS
Regular Visitor

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.

CyrillS_0-1695705491861.png

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. 

CyrillS_1-1695705810677.png

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.

CyrillS_2-1695706081139.png

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

1 ACCEPTED SOLUTION
avatar user
Anonymous
Not applicable

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

View solution in original post

2 REPLIES 2
olinayras
New Member

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?

avatar user
Anonymous
Not applicable

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

avatar user

Helpful resources

Announcements
Join our Fabric User Panel

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.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)