Percentage Not on the Overall Amount

DAX DAX Calculations
1

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
image

Capture

2

Hi @mohammedkhan11. Please provide your work-in-progress PBIX (using sample data, if necessary) to aid the forum members in their analyses.
Greg

4

Hello @mohammedkhan11, we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster.

While waiting for a response, here are some tips so you can get the most out of the forum and other Enterprise DNA resources.

  • Use the forum search to discover if your query has been asked before by another member.
  • When posting a topic with formula make sure that it is correctly formatted to preformatted text </>.

image

  • Use the proper category that best describes your topic

  • Include the masked demo pbix file, and any other supporting links and details.

Check the How To Mask Sensitive Data thread for some tips on how to mask your pbix file.

I also suggest that you check the forum guideline How To Use The Enterprise DNA Support Forum.

Please be reminded that not adhering to it may sometimes cause delay in getting an answer. We’ll be tagging this post as SOLVED should there won’t be any activity in this thread due to incomplete information. Thanks!