Forum Discussion

Quakker's avatar
Quakker
Helper II
3 years ago
Solved

Filter on multiple Columns / Values - Data Consolidation - Sample Data

  Filter on multiple Columns / Values - Data Consolidation ‎06-06-2023 12:05 PM Hi All, i´m struggeling to create a Costcenter Report, where some kind of consolidation has to be done. Atta...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Quakker ,

     

    I suggest you to try to create a measure to filter your visual.

    Filter = 
VAR _SELECT = VALUES(DimCostcenter[COSTCENTER])
RETURN
IF(MAX('Table'[COSTCENTER]) IN _SELECT || MAX('Table'[SOURCEOBJECT]) IN _SELECT,1,0)

    Add this measure into visual level filter and set it to show items when value =1.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Quakker ,

 

I suggest you to try to create a measure to filter your visual.

Filter = 
VAR _SELECT = VALUES(DimCostcenter[COSTCENTER])
RETURN
IF(MAX('Table'[COSTCENTER]) IN _SELECT || MAX('Table'[SOURCEOBJECT]) IN _SELECT,1,0)

Add this measure into visual level filter and set it to show items when value =1.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.