Forum Discussion

JohnCowx's avatar
JohnCowx
Frequent Visitor
6 years ago
Solved

Filtering in measure CALCULATION

Hi I have a calculation which I cannot get the filtering right for.   I have the following tables joined on Date[Date]=dayMax[day]   I want a measure to calculate the AVERAGE of MaxOccupie...
  • az38's avatar
    az38
    6 years ago

    Hi JohnCowx 

    try smth like

    ALLSELECTED(dayMax[WEEKDAY]) or ALLSELECTED(dayMax)