Sum of a Measure

[Sai_Alkesh]

Hi

I was assited by @parry2k who helped me in creating a measure which references to a second slicer.

I need assistance on the below-

I need to use that measure for further calculations. In the calculations, i am having to do few arthimetic calculations on other measures created. One of the calculations required is to divide the value of the measure1 by sum of measure2

Can someone please guide me on how to sum up measure2 so that i can include that in my other calculations.

Thank you in advance.

[v-shex-msft · Accepted solution]

HI @Sai_Alkesh ,

You can try to add a variable table with summarize function and measure to manually calculate measure result, then use iteration functions to summary these records.

For example:

Measure2 =
VAR temp =
    SUMMARIZE ( Table, [Column1], [Column2], [Column3], "Result", [Measure1] )
RETURN
    SUMX ( temp, [Result] )

Regards,

Xiaoxin Sheng