Forum Discussion

evalromf's avatar
evalromf
Helper I
9 years ago

AND IF in conditional column

Hi,   I'm trying to create a new column that should be populated with a certain number based on the contents of several other columns.   What I'm looking for is something like this:   If [COUNT...
Need Help
GilbertQ's avatar
GilbertQ
Super User
6 years ago
You could try it with a Variable such as below

My Measure =
VAR ValueToGet = SELECTEDVALUE(TableName[BillingMethod])

RETURN
IF(ValueToGet = "FP", [Total_Invoice].[Total_InvoiceTM])
Anonymous's avatar
Anonymous
Not applicable
6 years ago

GilbertQ 

 

Thank you so much, it worked. I am new to learning power bi and dax. Can you please any book or online course where I can learn better and explore on myself.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    GilbertQ 

    Michiel 

     

    My Measure is giving correct result acorss column ie column subtotal is correct but row subtotal is wrong.

     

    Can you suggest what could be wrong.

  • Michiel's avatar
    Michiel
    Resolver III
    6 years ago

    'Wrong totals' is usually an effect of misunderstanding what the total row contains: it is not the total of the rows above, it's the result of the same measure in a different context, in this case without the row identifiers filtered.
    So your measure is not a simple SUM, but you do want the total to add up. The solution in this case is to force DAX to calculate results on a row-by-row basis, you can do this with SUMX. Trying to mimic your model:

    SUMX(VALUES(ProjectTable[Complete Project Detail]), [Your original measure])

    or, if Complete Project Detail is unique in the Project table:

    SUMX(Project, [Your original measure])

     

    If you don' want to call another measure [Your original measure] but want to include the logic in this measure directly, it's probably safest to wrap it in CALCULATE:

    SUMX(
        VALUES(ProjectTable[Complete Project Detail]),
        CALCULATE(<Your original formula goes here>)
    )

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    My measure is having the above calculation. The main measure is " Pay Distribution Project" . Can you please suggest now ,where I am going wrong.