Rule with dax

[Nihed]

Hello,

How do i apply this rule in dax please

IF 'PPM'[Steps] in {"Open for competition","Technical Evaluation Stage","Financial Evaluation Stage","Procurement Board","Legal Review","Contract Signature",""} then AMOUNT = 'PPM'[Estimated Amount]

IF 'PPM'[Steps] = "Process Finalized"  then AMOUNT = 'PPM'[Cumulated Contract Amount]

Thank you

[smpa01]

@Nihed 

switch(true(), 
     'PPM'[Steps] in {"Open for competition","Technical Evaluation Stage","Financial Evaluation Stage","Procurement Board","Legal Review","Contract Signature",""} 
	 ,'PPM'[Estimated Amount]
	 'PPM'[Steps] = "Process Finalized", 'PPM'[Cumulated Contract Amount])

[Nihed]

I did it like this but it doesn’t work 😕

[smpa01]

@Nihed  provide some more details then; e.g. sample data and expected output

[Nihed]

This KPI is displayed in the following table:

I must calculate the AMOUNT field

The metric is defined below:

KPI	Source	Filters	Source fields	Rules
Amount	PPM tab	Type = “CFT”	Cumulated Contract Amount Estimated Amount	IF 'PPM'[Steps] in {"Open for competition","Technical Evaluation Stage","Financial Evaluation Stage","Procurement Board","Legal Review","Contract Signature",""} then AMOUNT = 'PPM'[Estimated Amount] IF 'PPM'[Steps] = "Process Finalized"  then AMOUNT = 'PPM'[Cumulated Contract Amount]

[smpa01]

@Nihed  please provide sample data in table format

[Nihed]

I share with you the link for the example of data in pbix.

Thank you

https://we.tl/t-WJgFSTmRDC 

[smpa01 · Accepted solution]

@Nihed  I believe you are looking for this, pbix is attached

Column 2 =
IF (
    PPM[Process Steps]
        IN {
        "Open for Competition",
        "Technical Evaluations",
        "Financial Negotiations",
        "Procurement Board",
        "Legal Review",
        "Signature",
        ""
    },
    PPM[Estimated Amount],
    IF ( PPM[Process Steps] IN { "Finalised" }, PPM[Cumulated Contract Amount] )
)

else

Column = SWITCH(TRUE(),
                CONTAINSSTRING(PPM[Steps],"Open for competition")=TRUE()||
                CONTAINSSTRING(PPM[Steps],"Technical Evaluation Stage")=TRUE() ||
                CONTAINSSTRING(PPM[Steps],"Financial Evaluation Stage")=TRUE() ||
                CONTAINSSTRING(PPM[Steps],"Procurement Board")=TRUE() ||
                CONTAINSSTRING(PPM[Steps],"Legal Review")=TRUE() ||
                CONTAINSSTRING(PPM[Steps],"Contract Signature")=TRUE() , PPM[Estimated Amount],
                CONTAINSSTRING(PPM[Steps],"Process Finalized")=TRUE(), PPM[Cumulated Contract Amount])