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