Column not reacting to Slicer DAX

[Stuquan]

Hi everyone,

I'm fairly new to PowerBi; starting to get the hang of it but I'm having trouble finding any article/help on my particular issue, I'll try be as succint as possible.

Basically, I have a sum'd column not reacting to a particular slicer called 'Status'. I have two columns showing different amounts, Column 'Sum_Per_Week' is correctly reacting when I apply the slicer, this is a measure column. Column '£_Sum' is not reacting correctly, this is a column using a Summarize & Sum function (I believe this is a virtual table but correct me if I'm wrong).

The overall issue is that, the cumulative value column is showing the incorrect figure because it references my '£_Sum' column (and I cannot change the column reference to 'Sum_Per_Week' in the 'Cumulative_Value' formula, it can't seem to find reference to it, I believe DAX can't reference a measure column inside another measure?)

Here's a link to my project: https://www.dropbox.com/s/x8wdt8otx1hlt13/CH%20Link2.0.pbix?dl=0

I'd greatly appreciate any advice and/or help.

Many thanks,

Stewart

[littlemojopuppy]

Hi @Stuquan if what you're asking is why isn't a calculated column changing with a slicer it's because it's won't.  Calculated columns and tables are only calculated when data is refreshed.  If you want something that will be responsive to slicers, you need to use a measure.

[Stuquan]

Hi @littlemojopuppy, thanks for getting back to me. I perhaps wasn't clear enough, my 'Sum_Per_Week' column is a measure, but I cannot use it in my 'Cumulative_Value' measure which totals the previous weeks total to the current weeks, it doesn't seem to be able to find the 'Sum_Per_Week' measure when I try to reference it in the table|column part of that formula.

[littlemojopuppy · Accepted solution]

@Stuquan gotcha.  Looking at your file right now.  This is overcomplicated because you don't have a date table.  I would strongly recommend that you create one and mark it appropriately.  If you do that, there's no need to create a virtual table for the visualization...just a couple very simple measures.  There really isn't a need for a virtual table at all.  But your measures would be simpler than what you're currntly working with.

Someone else could probably create the measures you're looking for but your real, underlying problem is the data model itself.

[Stuquan]

Hey again @littlemojopuppy. Thanks very much for your insights, I totally agree it is very messy and I will look to clear it up. I actually did get it working just now believe it or not! For anyone else reading this with perhaps a similar issue: I was trying to sum up a sum in my cumulative value column (doh!), all I had to do was aim it at the raw data once again and apply the correct filters and it seems to be working. 

Thanks again though, it is good to talk these issues out with people.

[littlemojopuppy]

@Stuquan glad you got it to work!  🙂