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 hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.