Use total from a matrix table in a measure

[Lancelot]

Hi

Is there a way to use the auto calculated total value from a matrix table in a new measure?

This is the value generated. How do I refer to it? Thanks

[v-xinruzhu-msft]

Hi @Lancelot 

You can use sumx ()

e.g In the following matrix visual:

We substract the num "42" in Total, then we can create the following measure:

Measure = SUMX(FILTER(ALLSELECTED('Table'),[True/False]=TRUE()),[Order])

Best Regards!

Yolo Zhu

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

[Idrissshatila · Accepted solution]

Hello @Lancelot ,

You could include it in the new measure as a variable and use it.

Refer to this link https://learn.microsoft.com/en-us/dax/best-practices/dax-variables

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin