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.

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

Hi Mostafa-Hussien ,

I think it is because of the ALLSELECTED function that you have in Measure3.

Please comment it and let me know the result.

 

Regards,

Loran

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] )

     

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

      Thanks MohammadLoran25 

      This works fine for returning positive and negative values and correct total

      But how can i retrieve only positive values while retaining a correct total ?

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

        Your [measure3] only returns postivie value so the measure I sent recently should work for positive values.