Find my approach as reference below and stored in attached workbook version 10.4 located in the original thread.
a. Define a Union
b. Define a calculated field: NMD. Measure Display:
if [Table Name]='Sheet1' then 'Blue'
elseif [Table Name]='Sheet11' then 'Green'
elseif [Table Name]='Sheet12' then 'White'
elseif [Table Name]='Sheet13' then 'Yellow'
c. Define a measure: Measure:
if [Measure Display]='Blue' then [Blue]
elseif [Measure Display]='Green' then [Green]
elseif [Measure Display]='White' then [White]
elseif [Measure Display]='Yellow' then [Yellow]
d. Define a action
Hope it helps.
Action example.twbx 24.2 KB
Thanks for your effort. I understood the approach you implemented.
In my real world, I have more than 1000000 records. If I go with UNION then it will duplicate the data and it shows the impact on dashboard performance.
Is there any other way to meet this requirement without using UNION please?