How to use measure in slicer

[ksubramaniyam41]

I have measure this needs to use in slicer please help some one to resolve the issue. Because same meause if we create a column we didn,t get the expected result, only measure is getting expected result so this needs to use in slicer.

Measure = CALCULATE(DISTINCTCOUNT(TFlex_Usage_Report[USAGE_DT_DAY]),GROUPBY(TFlex_Usage_Report,'TFlex_Usage_Report'[USER_LOGIN_ID],'TFlex_Usage_Report'[Usage_DT_Year],TFlex_Usage_Report[Usage_DT_Month],TFlex_Usage_Report[USAGE_DT_DAY]))

[v-easonf-msft]

Hi, @ksubramaniyam41 

Unfortunately, using measure field in slicer is not supported.

You may need to create a separate calculated table for the return value of the measure.

Then add and apply custom filter to visual filter pane to filter data.

If possible, please share some sample data so that I can provide an example for your reference.

Best Regards,
Community Support Team _ Eason

[Greg_Deckler]

@ksubramaniyam41 In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...