Forum Discussion

elamad2024's avatar
elamad2024
New Member
1 year ago
Solved

Multiple measures based on table row values

What do I do wrong? I do not get any data for 2025.       Belastning Average_Utv = VAR SelectedDate = SELECTEDVALUE(DimDate[Date].[Date]) VAR DateFilter = DATESBETWEEN(DimDate[Date], DAT...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    Hi elamad2024  - modify your condition to check all of 2025 

     

    Belastning Average_Utv =
    VAR SelectedDate = SELECTEDVALUE(DimDate[Date].[Date])
    VAR DateFilter = DATESBETWEEN(DimDate[Date], DATE(2024,8,19), DATE(2025,12,31))
    RETURN
    IF(
    YEAR(SelectedDate) < 2025,
    CALCULATE(AVERAGE(Data[OnboardAtDep]), Data[OnboardAtDep] < 150 && Data[OnboardAtDep] >= 0),
    CALCULATE(AVERAGE(fact_sl_regular_traffic[adjusted_onboard_count]), fact_sl_regular_traffic[adjusted_onboard_count] < 150 && fact_sl_regular_traffic[adjusted_onboard_count] >= 0)
    )

     

    Hope this helps.

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi elamad2024 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.