Forum Discussion
Merging table visuals with different filters for each row
- 1 year ago
OK.
so here what you can do. Hope you already have different measures for those values. If not then create like belowUnknown DoB Measure = calculate(count(table, person ID), DoB=blank())
Unknown Postcode Measure = calculate(count(table, person ID), post code=blank())
and so on.Now you need to create a table named Query from Tab>enter data, put column name as Query and then enter all those caregories like "Unknown DoB","Unknown Postcode" ...... in that column and then load.
finally create a measure to switch
tabular values measure=switch(true(),
max(Query,Query)="Unknown DoB", Unknown DoB Measure,
max(Query,Query)="Unknown Postcode",Unknown Postcode Measure)
now create matrix , put the Query column in the row and the tabular values measure in the value pane. you will get the desired output.
Hi Ki2024
Did the solution Rupak_bi offered help you solve the problem. if it helps, you can consider to accept it as a solution so that more user can refer to, or if you also have some problems you can offer some information here so that can provide more suggestion for you.
Best Regards!
Yolo Zhu