100 % stacked graph

Thabang231 — Thu, 20 Oct 2022 09:15:44 GMT

Hi All

I am experiencing issues here, I wanna create a 100% stacked bar graph for the below graph but i seem not to win.

My dimension is : =If (Match([Group-Name],'Non-Perishables','Perishables','Freight and Warehousing') , [Group-Name])

my 1st measure is : COUNT(distinct if([Status] = 'In Service' AND [Binary] ='0',[Vehicle]))

my 2nd measure is COUNT(distinct if([Status] = 'Out Of Service' AND [Binary] ='1',[Vehicle]))

But my stacked cant do the 100% stacked please assist. Thank you in advance.

Re: 100 % stacked graph

vinieme12 — Fri, 21 Oct 2022 10:02:17 GMT

Measure1:

COUNT({<[Status] = {'In Service'}, [Binary] ={'0'} >} distinct [Vehicle]) / COUNT( distinct [Vehicle])

Measure2:

COUNT({<[Status] = {Out Of Service'}, [Binary] ={'1'} >} distinct [Vehicle]) / COUNT( distinct [Vehicle])