Values not reflecting correctly

[archuleta28]

Hi,

In my report, I have calculated efficiency % that shows correctly on one of the Power BI pages but for one specific page, it is not showing correctly, it varies.

I have checked at page level filter also but there are no additional filters applied to that page or that visual.

What can be the reason for this problem? Why is the efficiency not showing correctly on each page?

[amitchandak]

@archuleta28 , for that we need to check the data. May be you are showing with dimension not having a join or drill through filter is saved (check under visualization pane)

[archuleta28 · Accepted solution]

Hi, thanks for your quick response. I had checked in report, no drill through filter was saved. Though, I have added DAX for preventing filters being applied on this efficiency and it worked. 

Thank you, your helping gesture is much appreciated! 

[saadsajjad]

Can you please explain what you added in the DAX measure in order for it to work properly?

[archuleta28]

Hi, I had used ALL() to avoid unknown filters being applied. Hope, that's helpful to you.