Forum Discussion

YunJ's avatar
YunJ
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Filter in calculation

Hi, I wrote a measure as following. only filtered Category-L1, but the result doesn't match the excel file...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    YunJ ,

     

    This answer may answer your question.

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago

YunJ ,

 

As per your screen shot, Brand and Category_FLag columns are filtered in Excel. And you only applied Category_Flag filter in your measure. Perhaps, that's why your answer is not matching.

 

You can either add Brand="3CE" in your measure along with Category_flag or clear Brand filter from excel and see the result.

 

 

YunJ's avatar
YunJ
Icon for Post Prodigy rankPost Prodigy
6 years ago

Hi Tahreem24 

What I compared in the screenshot is about 3CE no matter in excel or table in Power bi.

Please check my previous reply which is with pbix file. 

 

Thanks a lot for your help!1

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    6 years ago

    YunJ ,

    It gives blank page. Not able to download PBIX.

    • YunJ's avatar
      YunJ
      Icon for Post Prodigy rankPost Prodigy
      6 years ago

      Hi Tahreem24 

      May I know what's the difference between these two measures?

      • v-yuta-msft's avatar
        v-yuta-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        YunJ ,

         

        This answer may answer your question.

         

        Community Support Team _ Jimmy Tao

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.