topic Re: How to use measure in slicer in DAX Commands and Tips

How to use measure in slicer

ksubramaniyam41 — Wed, 26 Oct 2022 12:44:37 GMT

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]))

Re: How to use measure in slicer

Greg_Deckler — Wed, 26 Oct 2022 12:47:34 GMT

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/ba-p/279563

Re: How to use measure in slicer

v-easonf-msft — Mon, 31 Oct 2022 08:55:15 GMT

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