Forum Discussion

felipevaz's avatar
felipevaz
Helper I
7 years ago

Measure and Filter Context

Hi, :smileysad:   I did a measure that calculate the Sum of Distinct Values and I having issues while using that measure as a denominator. I dont know how to change the filter context os that measu...
Need Help
felipevaz's avatar
felipevaz
Helper I
7 years ago

The expected result using the Data Example:

 

SumOfFixedValue: 16+20+24 = 60

 

 

Final Result

SubCategory

DynamicValue

Average(DynamicValue/SumOfFixedValue)

aa

36

36/60 = 0,60

bb

35

35/60 = 0,58

cc

36

36/60 = 0,60

 

felipevaz's avatar
felipevaz
Helper I
7 years ago

My data is here, v-xicai could you try on this example? I cannot do as you explain.

 

Ive tried to create new columns...

 

The GrandTotal of Fixed Values is 59661 and they must to be always used as denominator.