Forum Discussion
krist_pbi
Helper I
Helper IHierachy within metrics
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 conversio...
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.