Forum Discussion
Create a custom table combining multiple measures
UPDATE: I don’t have a solution yet, but I’ve learned a few things, have hit a specific limitation and now at least may be able to form a more specific and targeted question that I will ask here.
I learned a way to create the table that I need which constructs its content based on some various measures that I am pulling in. A simplified version of it is as follows:
TestTable =
{
("TARGET: % of Revenue from subscription renewals", [January Target % of Revenue], [February Target % of Revenue], [March Target % of Revenue]),
("ACTUAL: % of Revenue from subscription renewals", [January Actual % of Revenue], February Actual % of Revenue], [March Actual % of Revenue]),
("ACTUAL: Amount of Revenue from subscription renewals", [January Renewal Revenue], [February Renewal Revenue], [March Renewal Revenue]),
("ACTUAL: Amount of Overall Revenue", [January Overall Revenue], [February Overall Revenue], [March Overall Revenue])
}
This kind of works. It works in the sense that I can use it to display the correct and accurate information in the single table visual that I need. So, yay!
The problem is that it doesn’t respond to filters on the page. The measures are written correctly, and if I display them individually on a simple card then they do respond to the page filters. But when the measures are used within this table as I’ve built, they do not.
So my hopefully better question is, how do I build a table in this fashion, leveraging measures as I need to, but get the measures used to populate the table to respond to filters?
Appreciate any direction anyone can provide – thanks!