Same amount of Total line

[EdgarasR1]

Hi,

I have problem with total line.

Maybe you have solution why in this table are the same total sum?

There is just one line where is different amount.

And somehow I get still the same total.

Measure4 formula = 

IF([Fact Amount]>[Plan Amount];0;'Planas vs Faktas'[Plan-Fact])

Thanks for solutions!

[v-eachen-msft · Accepted solution]

Hi @EdgarasR1 ,

You could try the following DAX:

Measure 4 =
SUMX (
    'Planas vs Faktas';
    IF ( [Fact Amount] > [Plan Amount]; 0; 'Planas vs Faktas'[Plan-Fact] )
)

Here is my test result.

[Anonymous]

Hi @EdgarasR1 ,

In your measure you've replaced the Fact_Amount as zero for Fact_amount less than zero.
Please share the same data to fix this.

Measure4 formula = 

IF([Fact Amount]>[Plan Amount];0;'Planas vs Faktas'[Plan-Fact])

Best Regards,
Mail2inba4

[EdgarasR1]

Hi,

Thats my table, and I add data.csv file.  Data.csv 

In excel are correct totals.

[Anonymous]

Hi @EdgarasR1 ,

Here fact amount is greater than Plan amount, as per your measure it returns zero.
Please let me know the what is your expected output.

Best Regards,
Mail2inba4

[EdgarasR1]

Yep, it brings zero. But why total line doesnt change?

Plan-Fact measure's total is 345661.61

So Measure4 total have to be 347825.72 because when Fact is bigger than Plan its have to be 0.

So instead of -2164.11 is 0

345661.61-(-2164.11)=347825.72

But its still shows the same total like Plan-Fact

[Tahreem24]

Hi @EdgarasR1 ,

if possible so can you please share the screen shot of your Fact Amount and Plan Amount fields as well.

[Tahreem24]

HI @EdgarasR1 ,

As per your Data your Fact Amount is greater than Plan Amount that's why you are getting Zero as per your condition applied in Measure. If possible so can you please share your actual requirement.