Forum Discussion

pavanpal1605's avatar
pavanpal1605
Frequent Visitor
3 years ago
Solved

Calculate based on the different values

Hi, I need help in calculating the AB Opportunity for a Product and Cat=AB, based on ID, Parent, Year.  Scenario1: The Total Sales for Product 'CARB' is 10,000 mentioned in column ' IDN_Prd_dollars'...
General Comment
  • amitchandak's avatar
    amitchandak
    3 years ago

    pavanpal1605 , Try a mesure like

     


    calculate(Max(Table[IDN_Prd_dollars]), filter(allselected(Table), Table[Product] = Max(Table[Product]) && Table[Year] = max(Table[Year]) ))
    - calculate(Max(Table[IDN_cat_prd_dollars]), filter(allselected(Table), Table[Product] = Max(Table[Product]) && Table[Year] = max(Table[Year]) && Table[Cat] = "AB" ))

amitchandak's avatar
amitchandak
Super User
3 years ago

pavanpal1605 , Try a mesure like

 


calculate(Max(Table[IDN_Prd_dollars]), filter(allselected(Table), Table[Product] = Max(Table[Product]) && Table[Year] = max(Table[Year]) ))
- calculate(Max(Table[IDN_cat_prd_dollars]), filter(allselected(Table), Table[Product] = Max(Table[Product]) && Table[Year] = max(Table[Year]) && Table[Cat] = "AB" ))

  • pavanpal1605's avatar
    pavanpal1605
    Frequent Visitor
    3 years ago

    Working!! Thanks a lot 🙂