Forum Discussion

calen's avatar
calen
Helper I
5 years ago
Solved

Filter is Filtering Too Much

Hello All!   I have been searching for about a week and have not found a fix to this problem. I'm hoping someone can point me in the right direction.    I have a report that compares current year...
Need Help
  • calen's avatar
    calen
    5 years ago

    Pragati11 Thanks for your help with this! It helped shift my train of thought which helped me solve it! I went to my data queries by clicking "Transform Data". From there I applied the filter. For some reason it works when applying the filter there instead of on the page level. 

colacan's avatar
colacan
Resolver II
5 years ago

calen  I can't be sure  100% without the pbix but,

I recomend to test Melt & Melt LY with card visual first (not matrix) to check whether it give desired result. 

If it give corrrect number, then maybe the filtering is afftected by other measures within matrix.

If it gives again blank, rather using page fiter, change the DAX code to exclude "Closing Income"
(by either filter the Description or adding condition in calculation)

 

Hope this helps.