Forum Discussion

Thunders's avatar
Thunders
Frequent Visitor
2 years ago
Solved

DAX formula

Hello team, I have following sititation: I have 2 tables, I need to create 3rd table. Using DAX summarize function I get product unique values (see required Output), but I'm strugling to bring quo...
  • FreemanZ's avatar
    FreemanZ
    2 years ago

    hi Thunders ,

     

    try to:

    1) add a calculated product table like:

    Product = VALUES(sales[Product])

     

    2) relate product[product] with sales[product] and quotas[product]

     

    3) plot a table visual with product[product] and three measures like:

    @sales = SUM(sales[Sales])
@Quotas = SUM(quotas[Quotas])
Attainment% = DIVIDE([@sales], [@Quotas])


    it worked like:

     

     

Thunders's avatar
Thunders
Frequent Visitor
2 years ago

Somehow still it is giving me hard time...se below.