I have what seems a very simple requirement to group the results of a measure into a chart whilst in direct query mode (client requirement as part of embedding).
I created a measure that groups my data into three sections based on if a project is ahead, on track or behind its target margin.
I can easily show my results by project in a table as below but then cannot simply drop a chart (donut) over this as you cant put the “variance” measure into the values field well.
If I wasn’t in direct query mode I would simply spin up a new table and create a custom column to store the variance results per project but I cannot do this as unable to use calculate as part of a calculated column in Direct Query mode.
Seems a simple ask but can’t see the simple solution?