Find the sum of a created measure

[mangobi]

I created a measure that is a time converted to number of minutes. However, when trying to find the total sum of these minutes, I am unable to locate the column in the table to create the formula. Would it be possible to find the sum of the measure in the table? 

Thanks 

[DOLEARY85]

Hi,

you can try:

 SUMX('Table Name',[Measure Name])

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

[mangobi]

Thank you! Would you happen to know why the value calculated by SUMX would be greater than the total value calculated under the table? 

[DOLEARY85]

Without having access to the PBIX i could only guess, how much greater is it? are there any filters on the table or slicers that only interact with that visual?

[mangobi]

It's a significant amount greater. There are filters applied to the table, so a better question would be would it be possible to use the total amount given at the bottom of the table in formulas?

[DOLEARY85 · Accepted solution]

You would have to apply the same filters to the measure

so you would do CALCULATE( SUMX('Table Name',[Measure Name]),Filter 1,Filter2...etc)

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