The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
User | Count |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |