Forum Discussion

Peppearson's avatar
Peppearson
Helper I
3 years ago
Solved

Combining Two Measures

Hi All,   I'm trying to create a measure which is a combination of two different measures and which changes in line with a date slicer.   Example   There are two data tables with actual sales a...
Need Help
  • Shaurya's avatar
    Shaurya
    3 years ago

    Hi Peppearson,

     

    You can try using:

     

    Combined = CALCULATE(SUM('Table1'[Actual Sales]), FILTER('Table1', MONTH('Table1'[Date])<=MONTH(SELECTEDVALUE('Filter'[Date])))) + CALCULATE(SUM('Table2'[Projected Sales]), FILTER('Table2', MONTH('Table2'[Date])>MONTH(SELECTEDVALUE('Filter'[Date]))))

     

    Works for you? Mark this post as a solution if it does!
    Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI

     

     

Shaurya's avatar
Shaurya
Memorable Member
3 years ago

Hi Peppearson,

 

You can try using:

 

Combined = CALCULATE(SUM('Table1'[Actual Sales]), FILTER('Table1', MONTH('Table1'[Date])<=MONTH(SELECTEDVALUE('Filter'[Date])))) + CALCULATE(SUM('Table2'[Projected Sales]), FILTER('Table2', MONTH('Table2'[Date])>MONTH(SELECTEDVALUE('Filter'[Date]))))

 

Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI

 

 

  • Peppearson's avatar
    Peppearson
    Helper I
    3 years ago

    Hi Shaurya 
    Thank you for your help.
    I used a variation on your dax code but turned both calculate formulas into variables.
    I also replaced the below in both formulas with the parameter value that I'm using.

    MONTH(SELECTEDVALUE('Filter'[Date])

    See below what the code ended up like.

    Combined =


    Var Actual Sales 
    CALCULATE(SUM('Table1'[Actual Sales]), FILTER('Table1', MONTH('Table1'[Date])<=Parameter[Parameter Value]))

    VAR ProjectedSales
    CALCULATE(SUM('Table2'[Projected Sales]), FILTER('Table2', MONTH('Table2'[Date])>Parameter[Parameter Value]))

    Return 
    If(ActualSales=0,
    ProjectedSales(measure),
    ActualSales+ProjectedSales