Forum Discussion

twister's avatar
twister
Regular Visitor
6 years ago
Solved

divide with condition less than

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 tot...
  • Mariusz's avatar
    Mariusz
    6 years ago

    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.

     

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
    twister
    Regular Visitor
    6 years ago

    nice..its work perfectly..thanks