Forum Discussion

jeoosma's avatar
jeoosma
Helper II
8 years ago
Solved

calculated field

Hi. I don't know if it is possible make what I want. In a page I have two table which origin is two different table. The two table have some rows and the total. I would create a field that has the di...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    jeoosma,


    You screenshot is not clear.

    Please try the DAX below.

    TableDifference = CALCULATE(SUM(CdmEtZKenR[Importo]);ALL(CdmEtZKenR)) - CALCULATE(SUM('CdmEtZKenR(2)'[Importo]);ALL('CdmEtZKenR(2)'))



    Regards,
    Lydia

  • jthomson's avatar
    jthomson
    8 years ago

    It's probably a filter issue, I can see you're trying to filter on just 2018 on that visual but we have no idea what you're doing on the other visuals, that we're using ALL is going to override it

jeoosma's avatar
jeoosma
Helper II
8 years ago

What I would is to create a field with difference between the total 1 and total 2.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago
    TableDifference = CALCULATE([Importo],ALL(Table1)) - CALCULATE([Importo],ALL(Table2))

    Not sure what the table names are for Table1 and Table2 but substitute the right table names.

    • jeoosma's avatar
      jeoosma
      Helper II
      8 years ago

      ?????? what am I doing wrong?

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        8 years ago

        You are in the Query Editor, you need to be in the Model in Desktop.

         

        Also, if Importo is not a measure, you will need an aggregator (SUM):

         

        TableDifference = CALCULATE(SUM([SomeMeasure]),ALL(Table1)) - CALCULATE(SUM([SomeOtherMeasure]),ALL(Table2))