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 certain rows of data. What would the dax formula be for the divide but filter on the value?
 
Thanks
 
Liam
Need Help

6 Replies

  • 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