Forum Discussion
calculated field
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,
LydiaIt'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
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))
I keep getting something wrong:manfrustrated:
As smoupre says, if it's not a measure (which it isn't, you're just referencing a column) you need to sum over the column
The "Importo" field is the result of the test on the "RechArt" value which defines the signe (positive or negative) of the ReBetrag value (in the CdmEtZKonR table). The same I do in the other table CdeAuftrag. So I have two field "Importo" from two table. In model section Smoupre says to insert the measure (how and where?) but I reveice an error (see the images I posted).
You can't insert the measure because you don't have a measure, either copy the DAX that's in post 7 (replacing Importo where he lists SomeMeasure) or make a measure that sums that column