Forum Discussion

powerbi_bi's avatar
powerbi_bi
Frequent Visitor
9 years ago
Solved

IF CONDITION

Hi, I have a table called "Fees" I'm using the below DAX formula to get the FeeAmount   FeeAmount :=     CALCULATE (         SUMX (             SUMMARIZE (                 Fees,             ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    I believe what you want is:

     

        CALCULATE (
        SUMX (
            SUMMARIZE (
                Fees,
                Fees[Report_Date],
                Fees[Employee_ID],
                Fees[Record_No],
                Fees[CreditAmount]
            ),
            Fees[CreditAmount]
        ),
        Fees[creditname] = "FeeAmount", Fees[STATUS] = TRUE
    )
Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

I believe what you want is:

 

    CALCULATE (
        SUMX (
            SUMMARIZE (
                Fees,
                Fees[Report_Date],
                Fees[Employee_ID],
                Fees[Record_No],
                Fees[CreditAmount]
            ),
            Fees[CreditAmount]
        ),
        Fees[creditname] = "FeeAmount", Fees[STATUS] = TRUE
    )
  • powerbi_bi's avatar
    powerbi_bi
    Frequent Visitor
    9 years ago

    Thanks