Forum Discussion
Helper IIIReport with a table with several measures
Hi all,
I have to create a report like below with several measures below eachother and with several periods. I am struggling to find the right approach to tackle this. Both table as also matrix do not seem to do the trick, so I was wondering if maybe this can be done with a calculation group? Any advice would be welcome.
Hi fjjpeeters1976
The solution involves a few steps:
First create a small help table consisting of the Names of your Measures. You can do this with Enter Data, or you can write it out in DAX as a Calculated Table if you wish:
Next, Create a Measure to conditionally return different Measures depending on the SelectedValue() of your Help Table:
Finally, putting it all together in a Matrix:
_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill DataHere's the pbix as well.
2 Replies
- Jonvoge
Most Valuable Professional
Hi fjjpeeters1976
The solution involves a few steps:
First create a small help table consisting of the Names of your Measures. You can do this with Enter Data, or you can write it out in DAX as a Calculated Table if you wish:
Next, Create a Measure to conditionally return different Measures depending on the SelectedValue() of your Help Table:
Finally, putting it all together in a Matrix:
_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data - Jonvoge
Here's the pbix as well.