topic Re: Matrix values issue in DAX Commands and Tips

Matrix values issue

NameTaken — Wed, 12 Jun 2024 20:18:10 GMT

Hello everyone,

I am trying to create a matrix that has both classifications and triggers where we are suming values (utilizing a case statement in my SSMS query). This part is working fine.

At the end of the matrix I am trying to add in some additional information, where we are taking the totals of the aforementioned and multiplying them by a PD and an LGD to get a reserve amount.

I was able to create a couple of measures that allow me to only show these PDs, LGDs and Reserves after the totals column and not in the value rows but they are still showing as blank column headers in the body of the matrix.

Total PD = IF(NOT(ISINSCOPE(Query2[Trigger])), MAX(Query2[PD]), Blank())

Total LGD = IF(NOT(ISINSCOPE(Query2[Trigger])), MAX(Query2[LGD]), Blank())

Total Reserves = IF(NOT(ISINSCOPE(Query2[Trigger])),SUM(Query2[Reserves]), Blank())

I am also having an issue with the 100% at the end of the PD/LGD totals as it is not necessary and should be blank.

I would like to get rid of/hide the highlighted sections in the screen shot below.

Failed solution attempts from youtube/internet: chaning color of text to match background color, removing totals in formatting pane, right click - exclude (ends up excluding the entire column not just the yellow), resizing columns.

I dont understand why its not as easy as right click - hide. Seems overly complicated for something so simple.

Thank you all for your time!

Re: Matrix values issue

Anonymous — Thu, 13 Jun 2024 01:10:41 GMT

Hi NameTaken

The PowerBI matrix is designed to be just that, and you can refer to the replies to this post to achieve the effect you want:
Solved: Remove/hide column on Matrix table - Microsoft Fabric Community
Solved: Matrix - Hide a column in visual but consider in c... - Microsoft Fabric Community

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Matrix values issue

NameTaken — Thu, 13 Jun 2024 14:53:47 GMT

Thank you Anonymous !!

This worked well to hide those columns. Nice simple approach.

For anyone wondering about the yellow highlighted totals at the bottom, I changed my PD and LGD measures to a bit with the guidance of the below:

IF(
    ISINSCOPE(F_AMOUNTS[Heading]) || ISINSCOPE(F_AMOUNTS[PARTS]), 
    SUM(F_AMOUNTS[Amount per unit]), 
    BLANK()
)

which I got from Solved: remove total of one column - Microsoft Fabric Community