Forum Discussion
Tricky: Filter measure from different datasets
Hi Quentin
You can create a Calculated table to put these Measures into one table.
Table =
var t1=ROW("source dataset","item sales","item total",[item total])
var t2=ROW("source dataset","store sale amount","amount total",[amount total])
return UNION(t1,t2)
The result looks like this:
Here is the pbix.
Best Regards,
CaiyunnZhengg
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello v-cazheng-msft,
Coming back on this subject, the problem is that calculated tables are not supported on composite model for the shedule refresh in the service...
Therefore i had to contruct visual by visual selecting the correct measure and playing with bookmark to allow filtering experience...
Not perfect for the moment...