divide with condition less than

[twister]

Hi All,

Anyone can help me to calculate this formula? I want to get cumulative value (in %) using below dataset.

Ex: (40/59) * 100

40 refer to ticket id which is FR_Hour < 5

59 refer to total ticket

Thanks

[Mariusz · Accepted solution]

Hi @twister 

Try something like this.

Measure = 
DIVIDE( 
    CALCULATE(
        COUNTROWS( 'Table' ),
        'Table'[FR_Hour] < 5 ),
    COUNTROWS( 'Table' )
) * 100

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

[twister]

nice..its work perfectly..thanks