Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I have attached the screenshots for refernece. Please check. Your kind help is very much appreciated.
I am supposed to dislay 100% total for each month, (please refer to the image attached) for say - all three dots of July should up to 100%, but currently all the dots from May to September add up to 100%. And I'm bound to use this simple line chart only.
I want to display 0-100% range on y-axis but not by manually changing the range value from format visual option. That won't work in this case anyways.
Please Note : I fear, I can't attach this .pbix file to this question as it has some confidentional data of patients.
Thank You! Kindly Help
Solved! Go to Solution.
Hi,
Try these measures
Count = countrows(Discharge dur to death)
Count across all exceptions = calculate([Count],all(Discharge dur to death[Exception]))
% = divide([Count],[Count across all exceptions])
Hope this helps.
Hi,
Try these measures
Count = countrows(Discharge dur to death)
Count across all exceptions = calculate([Count],all(Discharge dur to death[Exception]))
% = divide([Count],[Count across all exceptions])
Hope this helps.
Thank you so much, Ashish. It works 🙂 Can't thank you enough.
You are welcome.
hi, can you share Dax of measure %GT Count of Status
@tusharkumar ,when you use the line on the clustered line visual, it will not split by legend so you can not show % of Subtotal using that
% of Subtotal = Divide(Count(Table[Status]), Calculate(Count(Table[Status]), removefilters(Table[Exception])))
User | Count |
---|---|
94 | |
79 | |
73 | |
63 | |
59 |
User | Count |
---|---|
110 | |
103 | |
84 | |
65 | |
62 |