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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hello,

Did the solution johnt75  offered help you solve the problem, if it helps, you can consider to accept it as a solution so that more user can refer to, or if you have other quertsions, can provide some information so that can offer more suggestion for you.

 

Best Regards!

Yolo Zhu