Forum Discussion

mohammedkhan's avatar
mohammedkhan
Helper I
5 years ago

Percentage

Measure written down Helped me get the Percentages Changes on overall Amount i.e. this is being computed at the 3 years cumulative
____________________________________________________________________________

Rev_From_CU_Trial_Denom =
var mysel = SELECTEDVALUE('AFR Table'[GN])
return
CALCULATE(SUM('AFR Table'[Amount]),  FILTER(ALL('AFR Table'), 'AFR Table'[GN] = mysel), 'AFR Table'[Form] = "Schedule A")
_____________________________________________________________________________________

% Category =
DIVIDE([Revenue], [Rev_From_CU_Trial_Denom])
_______________________________________________________________

But now I would like to have the measure in a way that

% Category, should do the Changes based on GN Revenue and not only overall revenue as you can see % Category Changes is not equals to 100% 

 

 I want the That 100% break up in the % Category Measure