Forum Discussion
Filter in calculation
Hi, I wrote a measure as following. only filtered Category-L1, but the result doesn't match the excel file...
9 Replies
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
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.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!!!
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.
