Forum Discussion
Blake753
Helper II
Helper IIAdd in average line with filtering
Here's the link where they answered part of the question I am asking: https://community.powerbi.com/t5/Desktop/How-to-calculate-an-average-line-in-the-Line-Chart/td-p/232371 What I am looking f...
Hi Blake753 ,
Or try this.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Blake753Helper II
Helper IICan you elaborate on this please? I'm not quite sure what you are saying.
lbendlin
Super User
Super UserWhen you want to show a particular value AND you want to show the average across all values then you need to modify the filter context to remove your selected filter. That's what the "ALL('Fact Table')" part does in the CALCULATE() statement.
- Blake753
Can you put what you are saying in an example .pbix file and post that please?