Forum Discussion

bswylie's avatar
bswylie
Helper I
9 years ago
Solved

ALL() function ignored / inconsistent functionality when also using report level filter

While working on an analysis report we came across (what seems to be) an issue in Power BI, and are not sure if this is a bug or a misunderstanding on our part. In summary, a measure we have created ...
Need Help
  • bswylie's avatar
    bswylie
    9 years ago

    Hi,

     

    I got a response from Microsoft to my ticket and wanted to share the result. This did fix the problem as per screenshot below. I'm not sure why there is a difference between PBI and PowerPivot results, but I'm grateful to have something to work with. It is not clear whether the Power BI support team considers this a bug or not as they refer more to "problem" and "workaround". I was under the impression everything could be done from a flat table in PBI if only one source being used, but it's not much admin to add to link up at least. Thanks all for the input.

     

    Microsoft support response

    Use the ALL function on the dimension attribute instead of the column in the fact table, and use the slicer on the dimension attribute, this seems to workaround the problem.

     

     

bswylie's avatar
bswylie
Helper I
9 years ago

Hi all,

 

Can anyone tell me if this does seem to be a bug or if we are doing something wrong? Would greatly appreciate if anyone can respond and say whether they also find this strange behaviour?

 

Cheers

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    I took a look... and agree that something weird and broken is happening.  Definately use the "send a frown" feature of PBI Desktop, and attach your pbix file to the mail... the product team will take a look.

    • bswylie's avatar
      bswylie
      Helper I
      9 years ago

      Thanks so much, I really appreciate having someone else confirming this. I'll do as you recommend!