Difference in value between card/ multicard and funnel visualization

[dhritiman_b]

Hi,

I am facing a peculiar problem and I don't know what's exactly the issue . Infact I stumbled upon it by chance.

I was trying to create a measure which calculates the sum of values over a column using the calculate and previous month expression. ( Yes, I was trying to calculate the sum of values corresponding to the "previous month").

I was representing this visual on the funnel chart, but the funnel chart was not showing the current summation. I though there was an error with DAX formulation and tried to rewrite the expression using DATEADD, or even FILTER. But, every way the funnel chart showed the same wrong value.

Then I tried showing the same measure with a different visualization and tried the card visualuzation and immediately the card showed the correct value!!.

On switching back to funnel, the value once again switched back to the wrong value.

I just can't make any head or tail of this. Could someone help me with where I am going wrong?

[parry2k]

@dhritiman_b what is yur DAX formula? And also your data model?

[dhritiman_b]

Hello Parry,

My DAX formula is as follows:

Previous Backlog = CALCULATE(sum('Planner In'[Current Backlog]),filter('Planner In', month(today()-1)))

The data model consists of a [Forecast date] column which is used as a slicer on the report page.

The [Current backlog] is a column of values in percentage.

The objective is to show the running total of current back log for all months upto the slicer month.