Need ideas on how to see data behind calculated measure

[mohammadbawany]

Hi all,

I need some help badly. There is a report with that has data that goes all the way to individual contracts. The graphs all show data that are made from calculated measures. These measures are calculated using other calculated measures.

I am being asked to create a way for the user to see contracts that create a point on a graph. I know the 'See Records' does not work with calculated measures. I tried making a drillthrough page with a table full of contract data and using the 'keep all filters'. That didn't seem to do the trick.

Essentially I am borderline thinking that this is downright impossible. I tried to do my research and could not find much.

I very much appreciate any and every help in this matter.

[v-yuta-msft · Accepted solution]

Hi mohammadbawany，

If you mean you want to see records of measure, you can simply click ellipse on the top-right-> show data like below:

 

If you mean you want to show all records related to your measure, you can customize a tooltip where you can put all the related columns in the tooltip field. Please refer to: https://docs.microsoft.com/en-us/power-bi/desktop-custom-tooltips

Regards,

Jimmy Tao