Forum Discussion

NameTaken's avatar
NameTaken
Frequent Visitor
2 years ago
Solved

Matrix values issue

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! 

2 Replies