Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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])