Forum Discussion

Mostafa-Hussien's avatar
Mostafa-Hussien
Icon for Helper I rankHelper I
3 years ago
Solved

Cant get correct total on complex model

I have a complex data model imported from Oracle database, I am attaching a drawing of how it looks like.     I made a measure on a fact table "General Account" that works fine. It is basi...
  • MohammadLoran25's avatar
    MohammadLoran25
    3 years ago

    You're welcome,

    Yes I tried it in the file you sent and it worked.

    No worries.

Mostafa-Hussien's avatar
Mostafa-Hussien
Icon for Helper I rankHelper I
3 years ago

I cannot drop the ALLSELETED(), otherwise it will not aggregate regardless of the ALLSELECTED arguments.

I mean; I added certain columns to ALLSELECTED like CLIENTID, because I want an aggregate value regardless of CLIENTID

MohammadLoran25's avatar
MohammadLoran25
Icon for Solution Sage rankSolution Sage
3 years ago

Not the best solution, but as an easy and fast solution to fix it, please try this as well. It should work for your total:

Measure =
VAR _TABLEE =
    ADDCOLUMNS (
        SUMMARIZE (
            GENERAL_ACCOUNT,
            GENERAL_ACCOUNT[BU],
            GENERAL_ACCOUNT[Link],
            GENERAL_ACCOUNT[ACCOUNTCODE]
        ),
        "@measure3", [measure3]
    )
RETURN
    SUMX ( _TABLEE, [@measure3] )