Is Drill through to another report possible based on column value(Calculated measure) in PowerBI?

[Anonymous]

Can any one please help in finding an approach to drill through to another report based on the values that are there in matrix visual.

Scenario: I have a matrix visual in one report (say Source report) in below format.

Project Manager	Funding Project	October	November	December	January	February	March	April	May	June	July	August	September
ABC	1234	$1,500	$900	$790	$1,350	$790	$900	$790	$790	$1,350	$1,350	$1,350	$1,350

All the months  are calculted measures and now when I drill through by clicking on the value of october month, it sholud take me to another report to display all the other details that are associated to that particular Project Manager, Funding Project and that particlaur month (October (i.e. $1500) )

The other report should look in this format.

Output: 

Category	SubCategory	Sales
Accessories	Pedals	400
Accessories	Tyres	600
Clothing	Shirts	500

Thanks,

Kalyan

[v-cazheng-msft]

Hi, @Anonymous 

You can refer Drillthrough on matrix measure with dax filters and Drill through for calculated measure.

Best Regards,

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.