Measure seems to be ignoring report level filter?

[Anonymous]

Hi,

I have a report level filter in but the measure I'm calculating seems to be ignoring it?  Not sure why this would happen.  Please help.

SA Final Yield % = 1-(SUM(YieldDataTable[Rework_SA_M2])+SUM(YieldDataTable[Scrap_SA_M2]))/Sum(YieldDataTable[RunQuantity_SA_M2])

 In the table, run date and paint line description are both from YieldDataTable, so it shouldn't be a problem of the relationship.

Thanks.

[Greg_Deckler]

Why do you feel that the measure is ignoring the report level filter?

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

[Anonymous]

Because, as you can see in the screenshot, the measure is calculating 100% when quantity is blank.  I set the filter to be quantity >500.

[v-yuta-msft]

@Anonymous ,

Is there any value in quantity column in 1/3 and 1/4? If possible, could you please share some sample data?

Regards,

Jimmy Tao

[Anonymous]

Hi Jimmy,

There is no value in 11/2 and 11/3.  There is no data for those two days at all.  There is some sensitive data I couldn't share, but if you can let me know which data you are looking for, I could PM you a sample of those.

Thanks.

[v-yuta-msft]

@Anonymous ,

So it's blank in the two days, right? You can calculate a calculate column Data = Table[data] + 0 to replace the blank cell with 0 and then use the report level filter to filter these rows.

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.

[Anonymous · Accepted solution]

I did that and it did not work.  So I manually added this line to all of my measures, which works.  I'm tending to think that this is a bug.

IF(SUM('Production_History (2)'[Quantity])<500,BLANK(),FINAL)