Skip to main content
cancel
Showing results for 
Search instead 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

Reply
WTAS80486
Helper IV
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

 

WTAS80486_1-1680329412618.png

 

So when i collapse column C

 

WTAS80486_2-1680329540736.png

 

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

@WTAS80486 

Good. Then try

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

View solution in original post

11 REPLIES 11
tamerj1
Super User
Super User

@WTAS80486 

Try

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

@tamerj1 

 

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

 

WTAS80486_0-1680389584960.png

 

 

WTAS80486_2-1680389779673.png

 

 

@WTAS80486 

Good. Then try

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

@tamerj1 , It worked, Thank you so much!

Jihwan_Kim
Super User
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.


Go to My LinkedIn Page


tamerj1
Super User
Super User

Hi @WTAS80486 

something like

 

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

 

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

@tamerj1 when I use this

 

Final measure E=
IF ( NOT HASONEVALUE ( Table[D]), MINX(Table,Table[E]))
 
I get this when icon is expanded
 
WTAS80486_3-1680362183886.png

 


 

 

on collapse

 

WTAS80486_2-1680362147689.png

 


 

@WTAS80486 

Then use

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

 

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

@tamerj1  then everything disappears when i collapse C

 

 

WTAS80486_0-1680363812842.png

 

 

WTAS80486_1-1680363836459.png

 

 

@WTAS80486 

because it is blank. Please try

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

 

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

 

@tamerj1 

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

It becomes from this

 

WTAS80486_0-1680371105108.png

 to this

 

WTAS80486_1-1680371116549.png

 

Helpful resources

Announcements
Europe Fabric Conference

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.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.