topic Re: percentage of total based on category with date range in DAX Commands and Tips

percentage of total based on category with date range

amazinfarah — Tue, 22 Dec 2020 20:56:01 GMT

Hi Guys,

i have report where i am showing line chart. i want to show as total of percentage as you can see i am showing as count of id on date and and based on category

let suppose any data point show as below

count of order id segment order date

10 furniture 30/01/2019

20 office supplies 30/01/2019

70 technology 30/01/2019

what i want in line chart show as total percentage like below

count of order id segment order date percentage

10 furniture 30/01/2019 10%

20 office supplies 30/01/2019 20%

70 technology 30/01/2019 70%

like total count of day is 100 and 100% percentage is splitted by category (legend) how can i do that? date slicer in place too so range user can change

Re: percentage of total based on category with date range

amitchandak — Wed, 23 Dec 2020 02:14:01 GMT

amazinfarah , Drag the count measure again, right click on the meausre in visual pane and use option show as Percent of total

of create meausres like

divide([count of order id], calculate([count of order id], all(Table)))

divide([count of order id], calculate([count of order id], allselected(Table)))

refer: https://www.youtube.com/watch?v=6jTildcV2ho