Forum Discussion

Nihed's avatar
Nihed
Icon for Helper III rankHelper III
4 years ago
Solved

Rule with dax

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","Contrac...
  • smpa01's avatar
    smpa01
    4 years ago

    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])

     

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

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's avatar
    Nihed
    Icon for Helper III rankHelper III
    4 years ago

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

     

    • smpa01's avatar
      smpa01
      Icon for Community Champion rankCommunity Champion
      4 years ago

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

      • Nihed's avatar
        Nihed
        Icon for Helper III rankHelper III
        4 years ago

        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]