Dax Measure not behaving as expected. % one values is of total amount needed.

[Anonymous]

Hi, 

I'm looking for a measure that calculates the % that <1 hour makes up of the total amount. 

I've created a DAX measure to calculate this, which to me looks to be correct however it is not displaying the correct results. I can't figure out what is the issue with it. Measure is as follows: 

% < than 1 Hour =

VAR TotalCount =

COUNT ( 'Table'[Ticket_Duration_Hours] )

VAR LessThanOneCount =

CALCULATE (

COUNT ( 'Table'[Ticket_Duration_Hours] ),

FILTER ( 'Table', 'Table'[Ticket_Duration_Hours] <= 1 )

)

RETURN

DIVIDE ( LessThanOneCount, TotalCount )

In the picture below you can see that if you do the calculations on the numbers from the top visual you can see that the % values are not correct.

Week 26 for example : 319 / 755 = 0.42

However the measure is giving the result of 49.54%

Any help as to resolving this would be great thankyou. 

[mlsx4]

Hi! I would do it in separate measures to check what is happening. It is difficult to figure out the problem without the data, but it seems you need an ALL for the total tickets.