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.

     

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!