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])

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])