topic Re: divide with condition less than in DAX Commands and Tips

divide with condition less than

twister — Fri, 13 Dec 2019 07:26:15 GMT

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 — Fri, 13 Dec 2019 09:32:05 GMT

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 — Mon, 16 Dec 2019 00:19:41 GMT

nice..its work perfectly..thanks