Measures not filterable in calculated table

[Anonymous]

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

[amitchandak]

@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.

[Anonymous]

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

[amitchandak]

@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.