Forum Discussion
Solved
Create calculated table from multiple tables with sum and group by DAX
Hi, I have a problem that i´ve been struggling with. I want to create a preaggregated calculated table from 1 fact table and 2 dimensions. Fact FactKey Account Amount CostCenterId 1 ...
also try this:
Table =SUMMARIZE(Fact,DimReport[Report],
DimReport[Account],DimCostCenter[CostCenterName],"SumAmount", SUM(Fact[Amount]))
You will probably get more replies in you post this in the DAX section.
https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/bd-p/DAXCommands
Anyway, if you can access Power Query editor, using the function Group By to aggregate, and Merge to add those columns from dimension, will be easier.
Thank you so much for your reply! Yes i realize im in the wrong section 🙂 Im working with a tabular model in Visual studio so i can´t access the Power Query editor.