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.
v-saisrao-msft
Community Support
Community SupportHi MiKeZZa241,
Great to hear the issue got fixed. Please accept your reply as a solution so that other community members with the same issue can find it more easily.
Thank you.
I don't see that button/option somewhere??
- v-saisrao-msft
Hi MiKeZZa241,
Please refresh the page to see the "Accept as Solution" option, which you can find in the three dots menu mentioned above.
Thank you.
I know how it works, but it's not there...
- v-saisrao-msft
Hi MiKeZZa241,
Please try logging in from another system and check if the options are visible.
Thank you.