Hi friends,
I have one doubt here; please help.
Attached is a chart that I have created. Package is of DMR nature.
Series has a column called [Source of Feedback] where a slicer is applied to display only [CFPB] and [FRB] members. Additionally I need to display CFPB% as ( complaint volume for CFPB / complaint volume for CFPB across all quarters selected ). I am not able to find the expression for the denominator here.
What I used is:
_format ( ( total ( [Complaint Volume] within set [CFPB] ) / total ( [Complaint Volume] for report ) ), PERCENTAGE_2 )
which is not right.
Can you please help me get the right expression?