Forum Discussion

CTan42's avatar
CTan42
Icon for Helper II rankHelper II
9 years ago

same measure in every pages

Hi all, I have 5 tables (e.g. Table A, Table B, Table C, Table D, Table E). Below is the measure which i want to do: 1. CurrentMonth = sum('Table A'[Revenue]) 2. CurrentMonth = sum('Table B'[Revenu...
Need Help
CTan42's avatar
CTan42
Icon for Helper II rankHelper II
9 years ago

Thanks for the suggestion. However I dont really understand what you are saying. But the reason why i need to do the measure is I have to make a matrix table at the end with using the measure as the value in the matrix table. Or could show me the instruction?

Thanks

cs_skit's avatar
cs_skit
Icon for Resolver IV rankResolver IV
9 years ago

Maybe if you post your tables and what you need peoples can propose a solution.

 

Btw if its the same data structure in those tables you might want to merge them. Either in Query Editor or by New Table DAX

 

NewTableName =

UNION(

TableA; TableB; TableC; TableD; TableE

)

 

What you want in your original question is impossible each measure has to have unique name. But ihmo its the wrong question there is probably a better solution for your problem then what you want to do in your first post.