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 I

## matrix Removing Row totals at higher hierarchy and displaying Grand total

Hello All,
I am trying to customize a matrix visualization. this is my excpected Out put how can i achieve this ( Pictures atached).

1 ACCEPTED SOLUTION
Community Support

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.

5 REPLIES 5
Community Support

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.

Super User

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!

Proud to be a Super User!

Helper I

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 ???

Super User

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:

Proud to be a Super User!

Super User

@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.

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.

#### Power BI Monthly Update - June 2024

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

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors