I would like to calculate the percentage as sample below:
Let's say, I want to draw a column charge showing the percentage of Method A,B,C in North (which is 25%,75%,0% respectively). How should I do to get that measure?
Thanks for your help.
Go to Solution.
I'm getting total of A is 3000 as per the data you provided. I dont know how you got 4000.
if 3000 is correct count, try following dax.
View solution in original post
You haven't mentioned the total of delivered to calculate %. Suppose if it is 4000,
Create the column and use following dax
the total of delivery should be the sum of all delivery for each method:
Method A: 4000
Method B: 8000
Method C: 1000
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.