Need some ideas 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-danhe-msft]

Hi @mohammadbawany,
From your description, I could not understand "I know the 'See Records' does not work with calculated measures", it seemed work on my side:

Did I misunderstand you? Could you please post me your desired result if possible？

Regards,

Daniel He

[mohammadbawany]

I wanted to see all records that influenced in creating that point/area all the way to the the lowest grain. 

[v-danhe-msft]

Hi @mohammadbawany,

Could you please share some sample data to have a test if possible?

Regards,

Daniel He