The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to 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.
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.
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.
@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.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
80 | |
79 | |
47 | |
39 |
User | Count |
---|---|
149 | |
110 | |
66 | |
64 | |
56 |