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 work...
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.

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.