Total in matrix

[Anonymous]

Hi all,

In Power BI I have a matrix where I would like to add total records: is there any way the total for some fields could be a lookup that gets a value I already have in the data (in the data I already have a total record, I need the matrix to show the total just for layout reasons)?
I need to obtain something like this, where the total is the value for which "subcategory1" and "subcategory2" have the same value:

I successfully had this situation using Report builder for Power BI and now I'd like to replicate the format in Power BI.
Thank you!

[Anonymous · Accepted solution]

Hi @Anonymous ,

I'm not sure how you get this visual and the total value, better to share some sample data to us if you don't have any Confidential Information.

My current thought is to create two measures to replace value columns, such as below.

Measure = IF(SELECTEDVALUE('Table'[subcategory2])="A"||SELECTEDVALUE('Table'[subcategory2])="B",BLANK(),SUM('Table'[value1]))
Measure 2 = IF(SELECTEDVALUE('Table'[subcategory2])="A"||SELECTEDVALUE('Table'[subcategory2])="B",BLANK(),SUM('Table'[value2]))

Results comparison: 

It's just a thought, the values may not be accurate, and later we can filter and calculate the correct values by adding some conditions.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[Anonymous]

I don't understand the two subcategories as it makes the visual not really make sense becasue the total is totalling a subcategory two that now you cannot see. So I assume I am not understanding properly. 

However, my assumption would be to remove the second subcategory column and simply create a splicer to the side for the subcategory.