topic Re: How to display blank at summarized level in power BI matrix in DAX Commands and Tips

How to display blank at summarized level in power BI matrix

WTAS80486 — Sat, 01 Apr 2023 06:19:39 GMT

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

Re: How to display blank at summarized level in power BI matrix

tamerj1 — Sat, 01 Apr 2023 06:35:20 GMT

Hi WTAS80486

something like

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

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

Re: How to display blank at summarized level in power BI matrix

Jihwan_Kim — Sat, 01 Apr 2023 06:36:50 GMT

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

Re: How to display blank at summarized level in power BI matrix

WTAS80486 — Sat, 01 Apr 2023 15:17:15 GMT

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

Re: How to display blank at summarized level in power BI matrix

tamerj1 — Sat, 01 Apr 2023 15:40:25 GMT

WTAS80486

Then use

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

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

Re: How to display blank at summarized level in power BI matrix

WTAS80486 — Sat, 01 Apr 2023 15:45:44 GMT

tamerj1 then everything disappears when i collapse C

Re: How to display blank at summarized level in power BI matrix

tamerj1 — Sat, 01 Apr 2023 16:59:10 GMT

WTAS80486

because it is blank. Please try

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

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

Re: How to display blank at summarized level in power BI matrix

WTAS80486 — Sat, 01 Apr 2023 17:46:25 GMT

tamerj1

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

It becomes from this

to this

Re: How to display blank at summarized level in power BI matrix

tamerj1 — Sat, 01 Apr 2023 19:42:44 GMT

WTAS80486

Try

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

Re: How to display blank at summarized level in power BI matrix

WTAS80486 — Sat, 01 Apr 2023 22:57:26 GMT

tamerj1

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

Re: How to display blank at summarized level in power BI matrix

tamerj1 — Sat, 01 Apr 2023 23:08:33 GMT

WTAS80486

Good. Then try

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

Re: How to display blank at summarized level in power BI matrix

WTAS80486 — Sun, 02 Apr 2023 06:18:28 GMT

tamerj1 , It worked, Thank you so much!