Forum Discussion
MikeHendriks
Helper I
Helper ICorrupt Excel Pivottable; same number on all months
We have some Excel files connected to a semantic model hosted in Power BI. Worked perfect for long period but since a week we get users complaining about a behaviour that is completely wrong; the tot...
Issue is fixed. It seems to be caused by a DAX statement with a filter on the monthnumber which gives back different values for the same DAX statement with the same pivottable. Very strange, but fixed it with KEEPFILTERS.
Hi pborah the semantic model is the source for the Excel file