Forum Discussion

rhaddad87's avatar
rhaddad87
Icon for Helper I rankHelper I
4 years ago
Solved

Combine 3 measures into one DAX expression?

Hi there! I currently make a new measure every time I need to alter or calculate a result to display in my tracking dashboard.  Can you help me combine all of these to get the intended result?   F...
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi rhaddad87 

     

    Try this:

     

     

    final200 =
VAR _LastMX =
    CALCULATE ( MAX ( xxData[Date] ), CONTAINSSTRING ( xxData[Comments], "MX" ) )
VAR _HS200 =
    CALCULATE ( SUM ( xxData[Flight Hours] ), dimDate[Date] > _LastMX )
VAR _C200 = ( 200 - _HS200 )/ 18
RETURN
    TRUNC ( _C200 ) & " flights"

     

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

     

rhaddad87's avatar
rhaddad87
Icon for Helper I rankHelper I
4 years ago

VahidDM Vahid this works perfetly.  Thank you so much for your help!  Are you able to suggest any courses or specific topics that I should study to improve my understanding of DAX expressions and how to combine them?