Forum Discussion

AQ_2022's avatar
AQ_2022
New Member
4 years ago

Measure behave differently when data source is PBI dataset set

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
 
 
Need Help

2 Replies

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    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.

  • AQ_2022's avatar
    AQ_2022
    New Member
    4 years ago

    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.