topic Re: How to only show measure when specific dimensions is chosen in DAX Commands and Tips

How to only show measure when specific dimensions is chosen

Chancellor — Mon, 22 Aug 2022 12:49:20 GMT

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?

Re: How to only show measure when specific dimensions is chosen

Greg_Deckler — Mon, 22 Aug 2022 13:04:45 GMT

Chancellor Perhaps try HASONEVALUE instead of ISINSCOPE

Re: How to only show measure when specific dimensions is chosen

Chancellor — Tue, 23 Aug 2022 07:37:52 GMT

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.

Re: How to only show measure when specific dimensions is chosen

Greg_Deckler — Tue, 23 Aug 2022 16:21:07 GMT

Chancellor Wouldn't it just be:

IF(HASONEVALUE([Classtype]) && HASONEVALUE([Class]),[Population], BLANK())

Re: How to only show measure when specific dimensions is chosen

v-yadongf-msft — Wed, 31 Aug 2022 10:09:17 GMT

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.

Re: How to only show measure when specific dimensions is chosen

Chancellor — Fri, 02 Sep 2022 11:50:02 GMT

HI. Almost 🙂 I found a solution with IS IN SCOPE + IF. Thank you it helped .