cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper IV

## How to display blank at summarized level in power BI matrix

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

1 ACCEPTED SOLUTION
Super User

Good. Then try

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

11 REPLIES 11
Super User

Try

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

Helper IV

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

Super User

Good. Then try

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

Helper IV

@tamerj1 , It worked, Thank you so much!

Super User

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

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Super User

something like

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

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

Helper IV

@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

Super User

Then use

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

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

Helper IV

@tamerj1  then everything disappears when i collapse C

Super User

because it is blank. Please try

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

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

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

It becomes from this

to this

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.