Forum Discussion
Combine multiple measure in a single table without contradicting each other's filter
I have A measure in Table 1, and B measure in Table 2, they both have different data and of course, different filters and parameters. is there a way we can combine Measure A and B in a single ta...
Hi Anonymous ,
For example,your 2 measures are as below:
Measure 1 = IF(SUM('Table'[value])<4,MAX('Table'[category]),BLANK())Measure 2 = IF(MAX('Table (2)'[value])>5,MAX('Table (2)'[category]),BLANK())Then you could create a Union table as below:
Table 2 = UNION(CALCULATETABLE('Table',FILTER(ALL('Table'),'Table'[Measure 1]<>BLANK())),CALCULATETABLE('Table (2)',FILTER(ALL('Table (2)'),'Table (2)'[Measure 2]<>BLANK())))It will keep all the filters in both measures.
Check my sample .pbix file attached.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
v-kelly-msft
Community Support
Community SupportHi Anonymous ,
For example,your 2 measures are as below:
Measure 1 = IF(SUM('Table'[value])<4,MAX('Table'[category]),BLANK())Measure 2 = IF(MAX('Table (2)'[value])>5,MAX('Table (2)'[category]),BLANK())Then you could create a Union table as below:
Table 2 = UNION(CALCULATETABLE('Table',FILTER(ALL('Table'),'Table'[Measure 1]<>BLANK())),CALCULATETABLE('Table (2)',FILTER(ALL('Table (2)'),'Table (2)'[Measure 2]<>BLANK())))It will keep all the filters in both measures.
Check my sample .pbix file attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!