I have a measure as "Budget Amount" in the transaction table and this can be analyze by Project ID. Then I have another data sets with multiple percentages such as
Geographical
Asia : 30%, Europe 40%, Americas 30%
Gender:
Male 49%, Female : 51%
Theme
Forest 20%, Species 30%, Marine : 50%
and more. All percentages are by project ID too.
I want to create calculated measure (or something else) to get budget amount by project ID and by each percentage (by theme or gender or by Geographical) without breaking transaction table into details at the data warehouse database.