Forum Discussion

IvaStrezeva's avatar
IvaStrezeva
Frequent Visitor
6 years ago
Solved

DAX : Threshold trigger for product amount

Hello all,   I am a begginer user of Power BI and I would need help to set a treshold trigger for my data. Here are the tables: 1st Customer name, Invoice ref., Contract product and Amount 2nd Co...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi IvaStrezeva ,

     

    Please create a calculated column like that to work on it.

    Column = 
VAR ta =
    CALCULATE (
        MAX ( 'Product'[Threshold amount] ),
        FILTER ( 'Product', 'Product'[Product name] = Customer[Product Name] )
    )
RETURN
    IF ( Customer[Amount] > ta, "Over threshold", "ok" )

     

    Pbix as attached.

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi IvaStrezeva ,

 

Kindly share your pbix and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive for Business and share the link here.

 

IvaStrezeva's avatar
IvaStrezeva
Frequent Visitor
6 years ago

Hi v-frfei-msft ,

 

Unfortunately, the information is confidential and I cannot share it. 
I will try to work it out myself and will connect to you if any other questions!

Thanks a lot!

  • IvaStrezeva's avatar
    IvaStrezeva
    Frequent Visitor
    6 years ago

    Hello v-frfei-msft ,

     

    I found where the mistake was. As there are many repeated customers and invoices the column amount was checked to be "Sum". When I changed it to "Dont summarize" everything went well!

    So thank you very much for the formula, you have created!