Forum Discussion

amsrivastavaa's avatar
amsrivastavaa
Helper III
3 years ago

Measure Filter not working properly in Matrix Visual

Hi Folks!!

 

What I have done : 

 

Filters :

1- Project

2- Year

 

Measures : 

Measure2 = CALCULATE(SUM(Table1[Amount]),FILTER(ALLSELECTED('Table1'),'Table1'[Group]=MAX('Table1'[Group]) && 'Table1'[Year]=MAX('Table1'[Year] )))
 
Where measure2 is Sum of amount based on Group and Year
 
Measure3 = Divide(sum(Table1[Amount]),[Measure2])
 
Where Measure id division of Amount/Measure2
 
Selector 4 = IF([Measure3]<.25,1,0)
Where Selector 4 is the measure based on which I am filtering the tabular visual.
 
When, I have filtered Visual (Tabular), it gave me correct data but as soon as I try to convert it into Matrix, its not giving me correct result.
 
I have applied Selector 4=1 at visual level filter on both Tabular and Matrix
Can you please help me out to understand what need to be done in order to work in Matrix Visual as well.
 
Thanks
Amit 
PBIX is attached at below URL  
 
 
 
Need Help

1 Reply

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

    I cannnot understand the question.  In the left hand side table there is no 1 in the Selector 4 column.  so when i filter the second table with selector 4=1, nothing shows up (rightfuly so).  What exactly is the question?