Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Overall Sum for existing Measure

Hi Team,

 

I have done below measure_1 based on multiple if condition, now I want the overall sum of measure_1.

 

 

 

 

Thanks,

Udt_KV

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , measure like

    Assume product 1 and product 2 are measures then
    a new measure = if([Product 1] > 25 || [product 2] >13,1,0)

     

    then to add

    sumx( values(Table[Market]), [New measure])

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , measure like

    Assume product 1 and product 2 are measures then
    a new measure = if([Product 1] > 25 || [product 2] >13,1,0)

     

    then to add

    sumx( values(Table[Market]), [New measure])