Forum Discussion

josepcervello's avatar
josepcervello
Frequent Visitor
7 years ago
Solved

New table on a data model: Create a measure formula that changes depending on a column string value

I created a table on power BI that takes data from other tables which has the fields: KPI (Column)                |           Value (Measure) Revenues                     |            CALCULATE(SUM...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi josepcervello 

    You may add MAX fuction like below:

    Measure =
IF (
    MAX ( 'New_Table'[KPI] ) = "Revenues",
    CALCULATE (
        SUM ( 'F_Table'[Value] ),
        'F_Table'[Scenario] IN { "Actual" },
        M_Account[Level 7] = "Revenues"
    )
)

    Regards,

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi josepcervello 

You may add MAX fuction like below:

Measure =
IF (
    MAX ( 'New_Table'[KPI] ) = "Revenues",
    CALCULATE (
        SUM ( 'F_Table'[Value] ),
        'F_Table'[Scenario] IN { "Actual" },
        M_Account[Level 7] = "Revenues"
    )
)

Regards,