powerbi - How to translate a Tableau FIXED LOD to Power BI?

Question

I have a FIXED LOD with multiple dimensions that looks likes this:

{ FIXED [Customer ID], [Quarter], [Product Type] : SUM([Sales]) }

In Power BI I have wrote it as below using the example given in this article:

CALCULATE(
    SUM('Table'[Sales]), 
    ALLEXCEPT('Table', 'Table'[Customer ID]),
    ALLEXCEPT('Table', 'Table'[Quarter]),
    ALLEXCEPT('Table', 'Table'[Product Type])
)

However it is not working as expected, could you help me understand the correct way of doing it?

question from:https://stackoverflow.com/questions/65852528/how-to-translate-a-tableau-fixed-lod-to-power-bi

Answer 1

I found the answer by editing my original expression, the following worked as expected:

CALCULATE(
    SUM('Table'[Sales]), 
    ALLEXCEPT('Table', 'Table'[Customer ID], 'Table'[Quarter], 'Table'[Product Type])
)