Forum Discussion

NadiaLR1234's avatar
NadiaLR1234
Icon for Helper I rankHelper 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
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi burakkaragoz,

Thanks for reaching out.

Unfortunately, I can't receive files through email. But if you'd like, you can upload your pbix file here directly, and I’ll take a look. It might be an issue with the joins, so I’ll check the relationships and anything else that could be causing the problem.

 

Looking forward to helping you sort it out.

NadiaLR1234's avatar
NadiaLR1234
Icon for Helper I rankHelper 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
    Icon for Helper I rankHelper 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