So, I have a counter on top of my dashboard which has almost all the important measures (some amount fields and the number of records field) and I have some filters, now what I want to show is the percentage of total which is filtered out when I filter using one of those filters. I want a new row beneath those measure values in the counter which will show the % filtered out.
when I filter on Type A the counter should give me unfiltered amount in the 1st row for all the measures and % of total filtered out in the 2nd row for all the measures:
I solved this by creating a duplicate of the data source and then creating some new fields to which calculate the percentage by taking fields from both the data sources - one data source remains unfiltered and other is being filtered.
Still, let me know if there is another way of doing this. Thanks!