Forum Discussion

naelske_cronos's avatar
naelske_cronos
Icon for Advocate II rankAdvocate II
1 year ago
Solved

DAX - remove filter and add it again after full aggregation

Hello   I have a DAX question about remove filters:   This is my measure: _AverageMachineHoursV1 = CALCULATE ( AVERAGEX ( FILTER ( DIM_Date, YEAR ( [Date] ...
Need Help
  • johnt75's avatar
    johnt75
    1 year ago

    You could create a measure like

    Is Visible =
IF (
    SELECTEDVALUE ( DIM_Machine[DepartmentID] )
        IN VALUES ( DIM_Department[DepartmentID] ),
    1
)

    and add that as a filter to visual, to only show when the value is 1.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

You could create a measure like

Is Visible =
IF (
    SELECTEDVALUE ( DIM_Machine[DepartmentID] )
        IN VALUES ( DIM_Department[DepartmentID] ),
    1
)

and add that as a filter to visual, to only show when the value is 1.