Forum Discussion

Vindesh's avatar
Vindesh
Regular Visitor
4 years ago

Need Help

Hi, I have 3 tables (PrimarySales,SecondarySales and Hierarchy). Territory Column is common among them and i have joined Hierarchy table with PrimarySales and Secondary sales table on common Key(Te...
Need Help
PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

Can you show a depiction of how the model is set up please?

  • Vindesh's avatar
    Vindesh
    Regular Visitor
    4 years ago

    • PaulDBrown's avatar
      PaulDBrown
      Community Champion
      4 years ago

      Ok, you need a couple of measures (+ the sum for the sales in each table)

      Sales 1 where S2 > 90% =
VAR _90Threshold =
    DIVIDE ( [Sum Sales 1], [Sum Sales 2] )
RETURN
    IF ( _90Threshold > 0.9, 1 )

      Final = 
SUMX(VALUES('Hierarchy'[Region]), [Sales 1 where S2 > 90%])

       

      • Vindesh's avatar
        Vindesh
        Regular Visitor
        4 years ago

        Hi,

        Many thanks for your reply ans yes same objective even i want to achieve which i rflecting in your image.However,request you to explain bit in detail for measure creation part.