matrix Removing Row totals at higher hierarchy and displaying Grand total

[dhanekula1996]

Hello All,
I am trying to customize a matrix visualization. this is my excpected Out put how can i achieve this ( Pictures atached).
Please let me know If you need more info.

[Anonymous · Accepted solution]

Hi @dhanekula1996 ,

Please try:

Measure = IF(ISINSCOPE('Table'[Item]) ,SUM('Table'[cost]), IF(ISINSCOPE('Table'[Sample]),BLANK(),SUM('Table'[cost])))

Output:

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

[ValtteriN]

Hi,

This can be achieved by using ISFILTERED combined with IF. 

My example data:

The DAX I used:

Matrix with Blanks on lvl 1 = IF(

ISFILTERED('Matrix example'[Lvl 1])&&ISFILTERED('Matrix example'[Lvl 2])=FALSE(),"", //This checks if the current row is level 1 if so -> returns blank else returns the calculation below

SUM('Matrix example'[Value])) //Sum can be replaced with measure

End result:

Hopefully this helps and if it does consider accepting this as a solution!

[dhanekula1996]

Hello,
Thank you for your solution. WHen I have tried this I was able to show Blank values at Level 1 But my Row total per row (Left to right) is also showing as Blanck. I need to show value of the total in there as well. Like using SUMX ??? 

[ValtteriN]

Hi,

To solve this you can create separate total measure which doesn't have the ISFILTERED structure. So for example something like:

 [Total cost]=sum([cost])+sum([Max cost]). Then If you place this Into The Matrix the value will show. 

Example:

[amitchandak]

@dhanekula1996 , I doubt this is possible with standard visual,

 As a work around. You need to append data sample distinct values in the item table and the use option Show Item with no data.