Forum Discussion

NadiaLR1234's avatar
NadiaLR1234
Helper I
1 year ago
Solved

Measure with multiple conditions

Good day   I have the following measures   DT_RevenueSCG = IFERROR([TargetDayRevenueSCG],0) DailyTargetRevenueSCG = MAX(TTVBudget[DT_RevenueSCG])*Max(vw_TTV_REN[MaxDate2]) TargetDayRevenueSCG ...
Need Help
  • NadiaLR1234's avatar
    NadiaLR1234
    1 year ago

    I managed to get it to work without the date divide 

    thank you 

     

    TargetDayRevenueSCG =

    VAR SCG = SELECTEDVALUE(vw_TTV_REN[SalesChannelDescGroup])
    VAR Revenue =
        SWITCH(
            SCG,
            "Leisure", SUM(TTVBudget[LeisureRevenue]),
            "MICE/Logistics", SUM(TTVBudget[MiceRevenue]),
            "Transient", SUM(TTVBudget[TransientRevenue]),
            "Traveller Enablement", SUM(TTVBudget[TERevenue]),
            0
        )
    RETURN
        Revenue
NadiaLR1234's avatar
NadiaLR1234
Helper I
1 year ago

Unfortunately I can not add it on a public platform due to the confidentialy of the data - I will just play around with the table joins

Thank you

NadiaLR1234's avatar
NadiaLR1234
Helper I
1 year ago

I managed to get it to work without the date divide 

thank you 

 

TargetDayRevenueSCG =

VAR SCG = SELECTEDVALUE(vw_TTV_REN[SalesChannelDescGroup])
VAR Revenue =
    SWITCH(
        SCG,
        "Leisure", SUM(TTVBudget[LeisureRevenue]),
        "MICE/Logistics", SUM(TTVBudget[MiceRevenue]),
        "Transient", SUM(TTVBudget[TransientRevenue]),
        "Traveller Enablement", SUM(TTVBudget[TERevenue]),
        0
    )
RETURN
    Revenue