topic Re: Measures not filterable in calculated table in DAX Commands and Tips

Measures not filterable in calculated table

Anonymous — Tue, 26 Jul 2022 07:24:28 GMT

Hi all,

Hopefully someone can help.

I have a number of measures that all work with slicer as expected. In order for me to create a radar chart, I have constructed a new/custom table using union and row functions. The measures I am using are referenced in this calculated table. When I construct the radar chart it looks as expected. However, when I then click on a slicer, the chart does not change dynamically. (I have also viewed the calculated table in the matrix visual and the slicers have no effect here also. Seems that slicers are not filterable when in the table, but are when in a card, for example).

Does anyone know why the measures are not dynamic in the calculated table?

Kind regards,

Marc

Re: Measures not filterable in calculated table

amitchandak — Tue, 26 Jul 2022 08:00:12 GMT

Anonymous , A calculated table can not use slicer value , So if possible do not create a table.

Check if the calculation group can help

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Re: Measures not filterable in calculated table

amitchandak — Tue, 26 Jul 2022 08:00:14 GMT

Anonymous , A calculated table can not use slicer value , So if possible do not create a table.

Check if the calculation group can help

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Re: Measures not filterable in calculated table

Anonymous — Thu, 28 Jul 2022 16:03:14 GMT

Thanks for your reply amitchandak

I will watch the video and see if this can be done. I am using the calculated table to constrcut a radar chart and as a result a table is required to input relevant columns into the y-axis or categories fields.

Many thanks,

Marc