topic Re: Separate column wise Percentage based on the booking status count in DAX Commands and Tips

Separate column wise Percentage based on the booking status count

Anonymous — Mon, 10 Oct 2022 10:37:53 GMT

Hi Everyone ,

I have the data set like the below

Booking status Date

Confirmed April - 2022

Not Confirmed April - 2022

Amended April - 2022

Confirmed April - 2022

Confirmed May - 2022

Not Confirmed May - 2022

Amended May - 2022

How to get seperate Month column wise total percentage ?

plese find the attached Screen shot

Re: Separate column wise Percentage based on the booking status count

Anonymous — Tue, 11 Oct 2022 02:31:39 GMT

HI Anonymous,

What fields that you used to design the chart? Can you please share some more detail about these?

How to Get Your Question Answered Quickly

You can also try to use the following measure formula if helps:

Overall Percent by status type= DIVIDE ( CALCULATE ( COUNT ( Table[Booking status] ), ALLSELECTED ( Table ), VALUES ( Table[Date] ), VALUES ( Table[Booking status] ) ), CALCULATE ( COUNT ( Table[Booking status] ), ALLSELECTED ( Table ), VALUES ( Table[Booking status] ) ) )

Regards,

Xiaoxin Sheng

Re: Separate column wise Percentage based on the booking status count

Anonymous — Wed, 12 Oct 2022 06:56:23 GMT

Anonymous Thank you so much its working