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?