Forum Discussion

jkhan's avatar
jkhan
Icon for Helper III rankHelper III
5 years ago
Solved

DAX Help

Dear Power BI Gurus,   Please help to build below DAX, I need to make sum based on condition on different Tables and Sum them together  I tried to use below DAX but not working.    TOTAL IFC ALL...
Need Help DAX
  • Fowmy's avatar
    Fowmy
    5 years ago

    jkhan 

    Can you use this measure which I modified.

    TOTAL IFC ALL REVENUE ACTUAL =
VAR ifc =
    CALCULATE (
        SUM ( IFC_Monthly[Value] ),
        IFC_Monthly[Category] = "Revenue",
        IFC_Monthly[Period] = "Actual"
    )
VAR cpu =
    CALCULATE (
        SUM ( CPU_Monthly[Value] ),
        CPU_Monthly[Category] = "Revenue",
        CPU_Monthly[Period] = "Actual"
    )
VAR lounge =
    CALCULATE (
        SUM ( LOUNGE_Monthly[Value] ),
        LOUNGE_Monthly[Category] = "Revenue",
        LOUNGE_Monthly[Period] = "Actual"
    )
VAR md =
    CALCULATE (
        SUM ( MD_Monthly[Value] ),
        MD_Monthly[Category] = "Revenue",
        MD_Monthly[Period] = "Actual"
    )
RETURN
    ifc + cpu + lounge + md
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

jkhan 

You cannot add anything to the filter within CALCULATE like you have done + SUM ( CPU_Monthly[Value] ) .
Can you explain what is the logic that you need to apply to do the calculation also show picture of your model.