Solved: How to calculate a percentage with condition and g... - Page 2

Anonymous · ‎08-17-2018

Hi all,

I have a table containing different buildings, each building can have different batchs which can be booked or not.

I am trying to obtain the percentage of buildings where less than 3 batchs have been booked.

For example here I have, among 4 buildings, only one building which has more than 3 batchs booked (4):

In this case I expect the percentage to be 75%.

I don't manage to find the appropriate formula to calculate the percentage, I don't really know in DAX how to group by buildings with the condition.

Thank you in advance for your help!

Ashish_Mathur · ‎08-26-2018

Hi,

This measure works

=COUNTROWS(FILTER(VALUES(Operation[OPERATION]),[Nb réservations]=0))/COUNTAX(Lots,[Nb réservations])

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

How to calculate a percentage with condition and group by?