Separate column wise Percentage based on the booking status count

[THENNA_41]

Hi Everyone ,

I have the data set like the below 

Booking status                   Date         

Confirmed                        April - 2022

Confirmed                        April - 2022

Not Confirmed                 April - 2022

Amended                         April - 2022

Amended                         April - 2022

Amended                         April - 2022

Confirmed                        April - 2022

Confirmed                        May - 2022

Not Confirmed                 May - 2022

Amended                         May - 2022

Amended                         May - 2022

Amended                         May - 2022

How to get seperate Month column wise total percentage  ?

plese find the attached Screen shot

[THENNA_41]

@v-shex-msft  Thank you so much  its working 

[v-shex-msft · Accepted solution]

HI @THENNA_41,

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