Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @THENNA_41
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.
Hi @THENNA_41
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.
@THENNA_41 , 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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
46 | |
31 | |
30 | |
18 | |
18 |