Forum Discussion
Inverted Slicer Results
OwenAuger Thanks for your contribution on this thread.
Hi pablo2000325 ,
When creating a calculated table, it’s important to note that the data remains static regardless of filter or slicer options, as OwenAuger mentioned. To implement this, follow these guidelines:
1. Create a category dimension table (DO NOT create a relationship with the fact table).
Categories = VALUES('table1'[Category])2. Create a slicer and place the field [category] in the above dimension table on the slicer.
3. Create a measure as below
Mesasure = VAR _categories = ALLSELECTED ( 'Categories'[Category] ) RETURN CALCULATE ( MAX ( 'table1'[hour] ), FILTER ( 'table1', NOT ( 'table1'[Category] IN _categories ) ) )4. Create a table visual, put the field 'table1'[Category] and the above measure onto it
Best Regards
So table1 has development hours allocated per user and what I want to do is create a table2 which summarizes those development hours for users NOT in the slicer. The slicer currently adds the development hours based upon what is sliced so no issue with table 1. I hope this makes sense and thanks again.
OwenAuger Thanks for your contribution on this thread.
Hi pablo2000325 ,
When creating a calculated table, it’s important to note that the data remains static regardless of filter or slicer options, as OwenAuger mentioned. To implement this, follow these guidelines:
1. Create a category dimension table (DO NOT create a relationship with the fact table).
Categories = VALUES('table1'[Category])
2. Create a slicer and place the field [category] in the above dimension table on the slicer.
3. Create a measure as below
Mesasure =
VAR _categories =
ALLSELECTED ( 'Categories'[Category] )
RETURN
CALCULATE (
MAX ( 'table1'[hour] ),
FILTER ( 'table1', NOT ( 'table1'[Category] IN _categories ) )
)
4. Create a table visual, put the field 'table1'[Category] and the above measure onto it
Best Regards