Measure behave differently when data source is PBI dataset set

[AQ_2022]

Hi All,

I used this measure to count number of ID with group name = ABC while ignore any report level filter on group name. 

#ID = CALCULATE(count(Table[ID]), filter(all(Table[Group Name]),Table[Group Name] = "ABC"))

This measure worked perfectly on my PBI report with dataset, when I added page level filter Group Nme <> ABC, the #ID = 10. 

But when I publish this dataset and import it into a differet report, this measure stopped working, that is, when I add page level filter Group Nme <> ABC, the #ID = (blank). 

Is it a bug or where I did wrong? What is the workaround for this? 

Thank you.

Anna

[AQ_2022]

Hi Chenwu, thanks for replying my post. It is a flat table so no relationship at all.  No RLS applied either.  

Excat same report worked if it was in the report with dataset rather than a report importing the dataset. 

[v-chenwuz-msft]

Hi @AQ_2022 ,

As a rule, it would not look like this. ALL will remove all the filter. Is that the underlying table have no group = "ABC" in the published dataset? The user may has been applied with a RLS role, for the user, he has no row which group ="ABC".

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.