How do I create a measurement that will show the difference between 2 percentages?
Please note that 1st % is averaged, while 2nd % is another measurement.
Go to Solution.
Average 1st measure = Average([1st%])
Then diff = [Average 1st] - [2nd&]
If this does not work, please share a sample table of you original table, dax is based on data table not table visuals, so it is hard to say without data table.
Paul Zheng _ Community Support Team
View solution in original post
The 1st % is an aggregated average. If someone could help me to write a dax version of the aggregated average function that I clicked, as seen in the image that would be much appreciated.
Hey @rlee300 ,
you can just subtract the measures if you just want to get the difference:
% Diff = [1st %] - [2nd %]
Hi Denis, Unfortunately, the 1st % is not a measurement.
Click here to read more about the October 2021 Release!
Explore the latest tools,training sessions,technical expertise, networking and more.
Mark your calendars and join us for our next Power BI Dev Camp!