Hi Team,
Below is my DAX, I have slicers for Year, Month when I select Particular month from Slicer my values are not matching as in Image 2, If i dont use any slicer my data is working as expected in image 3. please help on this.
If I use ALL instead of ALLSELECTED the result is other way, data is matching with filter and it is not matching without filter.
Please help me
Hi @Anonymous
Do you have a slicer for Year and another slicer for Month? When you select a particular month from the Month slicer and the formula is using ALLSELECTED, the context will be the selected month in all years. So it may calculate the wrong running totals. I think using ALL will be better.
However I'm not sure why it is not matching without filter when using ALL. Perhaps it is related to the last part product_group? Do you have a slicer on product_group or add it to the same table visual?
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Helpful resources
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
FabCon &SQLCon Highlights
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
