Forum Discussion

MateuszBI's avatar
MateuszBI
Icon for Advocate I rankAdvocate I
8 years ago

SSAS tabular filters

Hi Power BI Guys! Does anybody know if anything changed in filters logic in connection to SSAS tabular model? Suddenly filters are filtering themselves and in some cases it does not work properly.
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi MateuszBI,

 

Are you using filters like visual level filter, report level filter or page level filter? Or a slicer chart in your report? What have you done before the error happens and what's the error message? Could you provide more details about yoru issue?

 

Regards,

Jimmy Tao

  • MateuszBI's avatar
    MateuszBI
    Icon for Advocate I rankAdvocate I
    8 years ago

    I have tried DAX studio and I am not sure but seems that there is kind of TOPN( 101, ... ) on filters that just do not give all set of informations in filter? This hint might get you to dead end though. 

     

    So see screenshots. I have values (actually columns) FALSE / TRUE on 2018 (this is two dimension relation) but when I do use filter then I do not have option to pick FALSE in Filters. It does not matter whether it is Visual/Page/Report level filter.