Forum Discussion

TrentS's avatar
TrentS
Helper IV
1 year ago
Solved

Summarize error but no Summarize function

Hi, Please help me make sense of this error. I cannot share the pbix file. The data source for this is a shared model. When creating a line chart, with PERIOD as the x-axis (a whole number refere...
Need Help
  • TrentS's avatar
    TrentS
    1 year ago

    Hi Akhil,
    Thanks for the follow up. We actually went another direction with the DAX in this case so it was not the solution in this case. However, I did forward your code on to the team for use in another similar situation.

    We appreciate your work there. Kudos given and thank you!

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi  TrentS 

Just following up to see if the revised DAX measure suggestion helped resolve your issue around the unexpected context behavior in the visual.

The restructured version using ALL('2FD_Fiscal Calendar') was intended to reset any lingering filters, especially if something like a hidden "Day" column was influencing the result.

If it worked as expected, please consider marking it as the accepted solution and giving it a kudos, it helps others in the community discover helpful answers more easily.

And of course, if you're still facing issues or need to tweak it further, feel free to share more context happy to help.

Best regards,
Akhil.