How to find the Percentage of based on the delay count

[Anonymous]

I am trying to find the  country percentage based on the Delay count .  I 

Country             DelayHour        

 Italy                      1
 Italy                      4

 Italy                      3

 France                  5 

 France                  2

 Spain                    1

Delay hour = CALCULATE ( COUNT ( 'Booking Acceptance'[Dealy in HRS] ), ALLEXCEPT('Booking Acceptance', 'Booking Acceptance'[Country] ) )

Percentage  = DIVIDE ( COUNT('Booking Acceptance'[Dealy in HRS]), [Delay hour ], 0)

this measure working with out slicer  if i select any country its showing  100% but i want  to seperate percentage for each country 

[v-xiaotang · Accepted solution]

Hi @Anonymous 

Thanks for reaching out to us.

the results of COUNT('Booking Acceptance'[Dealy in HRS]) and [Delay hour] are same,

please try this,

Percentage = 
var _count= CALCULATE(COUNTROWS('Booking Acceptance'),ALL('Booking Acceptance'))
var _delay= [Delay hour]
return DIVIDE(_count,_delay,0)

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Try like

Delay hour = CALCULATE ( COUNT ( 'Booking Acceptance'[Dealy in HRS] ), filter(allselected('Booking Acceptance'), 'Booking Acceptance'[Country] = max('Booking Acceptance'[Country]) ))

or

Delay hour = CALCULATE ( COUNT ( 'Booking Acceptance'[Dealy in HRS] ), filter(all('Booking Acceptance'), 'Booking Acceptance'[Country] = max('Booking Acceptance'[Country]) ))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

@amitchandak  sir i have tired this method when i convert  to Percentage not showing correct value . i have added sample test file for your reference . https://drive.google.com/file/d/1q5Q6cnr32qu60415R87FfzIlxqFSr8uh/view?usp=sharing