Forum Discussion
Helper IRFM Analysis Based on Year and Month Selection
The only change I made to my previous measure is shown below:
CALCULATETABLE(
'Invoice Header',
REMOVEFILTERS('Calendar'),
REMOVEFILTERS('Invoice Header')
)I used CALCULATETABLE to remove slicer filters so that the measure controls everything, not the visuals—and it worked.
Thank you.
Great to hear that the issue was with the filter and that it's now resolved and the measure is working as expected.
If you don’t mind, could you please mark your reply as the “Accepted Solution”? Also, if possible, sharing a brief summary of the fix would be really helpful for others who might face a similar issue in the future.
Thanks again for following up, and feel free to reach out if you need any further assistance.
Helper IThe only change I made to my previous measure is shown below:
CALCULATETABLE(
'Invoice Header',
REMOVEFILTERS('Calendar'),
REMOVEFILTERS('Invoice Header')
)
I used CALCULATETABLE to remove slicer filters so that the measure controls everything, not the visuals—and it worked.
Thank you.