Hi,
I am calculating a measure calculated dynamically based on other measures and has rangesum and after functions..is it possible to plot Treemap for this dynamically calculated measure?
Any hints or suggestions on this is much appreciated. Thank you!
Below Example is the dynamically calculated measure(JKQ) from ABC,XYZ & DEF and Using Rangesum and after
JKQ =
if(
Sum({$<[DATA_MEASURE]={'ABC'},WEEKLY_VERSION={'$(=vVersionselection)'}>}[VALUE])=0,0,
if(
RangeSum(after(Sum({$<[DATA_MEASURE]={'XYZ'},WEEKLY_VERSION={'$(=vVersionselection)'}>}[VALUE]),0,3))=0,99999,
if(
Sum({$<[DATA_MEASURE]={'ABC'},WEEKLY_VERSION={'$(=vVersionselection)'}>}[VALUE])<=0,0,
Sum({$<[DATA_MEASURE]={'ABC'},WEEKLY_VERSION={'$(=vVersionselection)'}>}[VALUE])
/
(
RangeSum(after(Sum({$<[DATA_MEASURE]={'XYZ'},WEEKLY_VERSION={'$(=vVersionselection)'}>}[VALUE]),0,3))
/
RangeSum(after(Sum( distinct {$<[DATA_MEASURE]={'DEF'},WEEKLY_VERSION={'$(=vVersionselection)'}>}[VALUE]),0,3)))
)
)
)
