How to display blank at summarized level in power BI matrix

[WTAS80486]

Hi,

I want to display  the values only at detail level and blank at summarized level in power BI matrix

So when i collapse column C

I wanted E and F to be blank

A, B & C are from first table and  D ,E ,F from second table and the two tables are joined on column A

and as shown A can have multiple values of D (that means second table has multiple instances of A) one to many relationship between 1st and 2nd table

[tamerj1]

@WTAS80486 

Try

Final Measure E = IF (HASONEVALUE(Table[D] ),MINX(Table, Table[E]),IF(NO ISEMPTY('Table'),""))

[WTAS80486]

@tamerj1 

Then it display blank for those rows which have multiple values of column D but not for the those which have single value

[tamerj1 · Accepted solution]

@WTAS80486 

Good. Then try

Final Measure E = IF( ISINSCOPE (Table[D] ),MINX(Table, Table[E]),IF(NOT ISEMPTY('Table'),""))

[WTAS80486]

@tamerj1 , It worked, Thank you so much!

[Jihwan_Kim]

Hi,

I am not sure how your datamodel looks like, but I suggesting using calculated measures for describing E and F, instead of just dragging columns directly from the table.
Please try using  SELECTEDVALUE DAX function.

SELECTEDVALUE function - DAX | Microsoft Learn

[tamerj1]

Hi @WTAS80486 

something like

IF ( NOT HASONEVALUE ( 'Table'[D] ), [Measure E] )

IF ( NOT HASONEVALUE ( 'Table'[D] ), [Measure F )

[WTAS80486]

@tamerj1 when I use this

Final measure E=

IF ( NOT HASONEVALUE ( Table[D]), MINX(Table,Table[E]))

I get this when icon is expanded

on collapse

[tamerj1]

@WTAS80486 

Then use

IF ( HASONEVALUE ( 'Table'[D] ), [Measure E] )

IF ( HASONEVALUE ( 'Table'[D] ), [Measure F )

[WTAS80486]

@tamerj1  then everything disappears when i collapse C

[tamerj1]

@WTAS80486 

because it is blank. Please try

IF ( HASONEVALUE ( 'Table'[D] ), [Measure E], "")

IF ( HASONEVALUE ( 'Table'[D] ), [Measure F], "" )

[WTAS80486]

@tamerj1 

Final Measure E = IF (HASONEVALUE (Table[D] ),MINX(Table, Table[E]),"")

It becomes from this

 to this