Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have at data set which in general is like this example:
| School | Class | Adress | Population | Classtype |
| Greenville | 1 | Littletown | 12 | A |
| Old public | 1 | Beartown | 2 | A |
| Blue Tech | 1 | Donkeytown | 41 | A |
| Greenville | 2 | Littletown | 3 | B |
| Old public | 2 | Beartown | 12 | B |
| Blue Tech | 2 | Donkeytown | 31 | B |
| Greenville | 3 | Littletown | 44 | C |
| Old public | 3 | Beartown | 12 | C |
| Blue Tech | 3 | Donkeytown | 12 | C |
I am trying to make a report where I only show the measure Population in the report when specific dimensions is chosen.
The rules are as follows:
A)When Class + Classtype is chosen in the filter then show Population
B)When All other dimensions in combinations with classtype is chosen then blank population
C)Else show population (e.g. all other filter values are accepted).
Im having a hard time especially regardring the B-part of the rules. Any suggestions?
I think A should be IF (ISINSCOPE ([Class]) && ISINSCOPE ([Classtype), Population)
Rest should be an OR statement nested - or what?
Solved! Go to Solution.
HI. Almost 🙂 I found a solution with IS IN SCOPE + IF. Thank you it helped .
Hi @Chancellor ,
Please try following DAX:
Measure =
var class_is_filter=HASONEFILTER(Sheet21[Class])
return
IF(class_is_filter,CONCATENATEX(Sheet21,[Population],"; "))
Is this the result you want?
If I misunderstand your demands, please feel free to contact us in time.
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI. Almost 🙂 I found a solution with IS IN SCOPE + IF. Thank you it helped .
@Greg_Deckler Thanks for the input. The problem with HASONE VALUE is it only filters correct if I choose a filter value.
Example:
Measuretest:= if (HASONEVALUE([Classtype])
&& or (HASONEVALUe ([Address]), HASONEVALUE([School])), BLANK(), [Population])
The input here only blanks classtypes when I filter on one value of adress or school. I want it to blank in ALL cases where I choose for examples adresse and classtype in the filter.
@Chancellor Wouldn't it just be:
IF(HASONEVALUE([Classtype]) && HASONEVALUE([Class]),[Population], BLANK())
@Chancellor Perhaps try HASONEVALUE instead of ISINSCOPE
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 6 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 14 | |
| 8 | |
| 8 | |
| 8 |