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.

     

     

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
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.