Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Total in matrix

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

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.