Filter in calculation

[YunJ]

Hi, I wrote a measure as following. only filtered Category-L1, but the result doesn't match the excel file...

[Tahreem24]

@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]

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]

@YunJ ,

It gives blank page. Not able to download PBIX.

[YunJ]

@Tahreem24 Would you please try this one?

https://www.dropbox.com/s/6tbhfs1b4dlt09q/0520.pbix?dl=0

the first dashboard.

Thanks a lot for your patience!

[v-yuta-msft · Accepted solution]

@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.

[YunJ]

Hi @Tahreem24 

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

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[YunJ]

Hi @amitchandak @Greg_Deckler 

Thanks for your reply. Please find my pbix file https://www.dropbox.com/s/sl0jjt513igil8v/0519%281%29.pbix?dl=0

Measure 2 is what I want. But i'm wondering what is the difference between measure 1 and 2. Why they have different result?

Thanks a lot for your help!!!

[amitchandak]

@YunJ , can not say without looking at data.

Can you share sample data and sample output.

Just check that non filtered data and the number of rows is matching. This means no data load issue. If they are not matching the check if there is a data load issue