Forum Discussion

Jake_Neyu's avatar
Jake_Neyu
Frequent Visitor
4 years ago
Solved

FILTER and ALLEXCEPT do not work in Matrix table

Hi,

 

I have coded a measure to calculate the total lead of top 20% agent in each source excluding all filters except for Source and Date. When I put it in normal table (table on the left), it works, but when I put it in a Matrix table (table on the right) it does not work.

 

Please advise me on this issue 😞

 

 

Need Help
Show and Tell
Tips and Tricks
  • Jake_Neyu's avatar
    Jake_Neyu
    4 years ago

    Hi mate,

     

    Thanks for your reply, I actually found a way to do it by using FILTER in the current measure and then create another measure to execute that measure with the ALLEXCEPT clause.

2 Replies

  • sturlaws's avatar
    sturlaws
    Icon for Resident Rockstar rankResident Rockstar
    4 years ago

    Hi,

     

    it is no obvious that the measure does not work in the matrix, the total is the same as in the table-visual. Also, the matrix goes on for much longer since Agent is added to it. There seems to be quite a few rows not visible in the screenshot, so no way to see if the numbers add up.

     

    Please share the pbix-file, or if that is not possible, create a sample report which reproduces the issue and share that.

     

    Cheers,
    Sturla

     

    How to Get Your Question Answered Quickly

     

    • Jake_Neyu's avatar
      Jake_Neyu
      Frequent Visitor
      4 years ago

      Hi mate,

       

      Thanks for your reply, I actually found a way to do it by using FILTER in the current measure and then create another measure to execute that measure with the ALLEXCEPT clause.