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