Forum Discussion

Ingan's avatar
Ingan
Regular Visitor
2 years ago
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 ...
Need Help
  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    2 years ago

    also try this:

    Table =

        SUMMARIZE(
            Fact,
            DimReport[Report],
            DimReport[Account],
            DimCostCenter[CostCenterName],
            "SumAmount", SUM(Fact[Amount])
        )
Tutu_in_YYC's avatar
Tutu_in_YYC
Super User
2 years ago

also try this:

Table =

    SUMMARIZE(
        Fact,
        DimReport[Report],
        DimReport[Account],
        DimCostCenter[CostCenterName],
        "SumAmount", SUM(Fact[Amount])
    )