Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Divide filter

Hi,   I have a calculation of dividing a measure by a measure:   Total Breached % = DIVIDE([Total Breached],[Count of Incidents]) + 0   I want to exclude a certain value that is attached to ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago
Divide(
Calculate([measure],filter(table,table[col]="value"),[measure2])

Thanks
Pravin

If it resolves your problem mark it as a solution and give Kudos.
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    Thanks for your reply.

     

    I currently have:

     

    Divide% = Divide(
    Calculate([Total Breached],filter(table,table[Key]<>"471"),[Count of Incidents]).
     
    This says too few arguments were passed to the divide function. The minimum is 2?
     
    Thanks in advance
     
    Liam
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous ,

         

        Thankyou, it now accepts this.

         

        I have both calculations next to each other in my matrix but the first divide displays all of the % as expected, but the new formula to filter out one of the rows, or display it as 0, displays blank on the whole column. Ive attached an image. 

         

         

         

        Would you have any idea why it displays like this?

         

        Thanks again for your help with this

         

        Liam