Hierachy within metrics

[krist_pbi]

Hey

I'm building a weekly scorecard and need the following:

I'd like to show weekly let's say conversion rate, but in the drill down show the two variables that are connected to the conversion rate ( clients in one row, and leads in the next row below) which are the variables to calculate the conversion rate, I need to replicate this for all the metrics I have, but the logic would be the same

Any thoughts on this? 

[Anonymous]

Hi, @krist_pbi 

I create a sample table:

Then create a new measure and calculated column, here is DAX expression.

Measure:

Conversion Rate = DIVIDE(SUM('Table'[Clients]), SUM('Table'[Leads]), 0)

Column:

Week Start = 'Table'[Date] - WEEKDAY('Table'[Date], 2) + 1

Put fields in matrix visual, here is my preview:

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.