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
Super UserHi pablo2000325
A calculated table like table2 does not respond to filters in a report.
It is processed as part of the semantic model refresh (in an unfiltered context), and from the report's point of view it is a static table.
Because all rows of table1 are visible in an unfiltered context, table2 is empty.
However, a table expression like table2 can be used within a measure, as a step to compute some other result.
What is the end result you are wanting based on table2?
I can probably suggest some options depending how you want to use it.
Regards