Forum Discussion

eCyrilD04's avatar
eCyrilD04
Frequent Visitor
4 years ago

Filter Working Differently in 2 Matrix

Hi, Anyone can help me on this. I'm trying to do a countrows on customers with sales in the current year(selected date) but using the measure I created in 2 different matrix where in matrix1 date ...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi eCyrilD04 ,

 

What is the expected result for these two matrix?

Please share some sample data so that we could reproduce the scenario.

 

Best Regards,

Jay

eCyrilD04's avatar
eCyrilD04
Frequent Visitor
4 years ago

Hi Anonymous ,

 

The data is source from a power bi dataset and so I'm not sure if the data can be downloaded to a pbix you can try to use this PBIX Link if its working.

 

But the scenario would be when sales column is <> 0 then it will show as 1 in aaaTest_CurrFYActive measure

however as you can see in the upper matrix of the screenshot where the date was in the row value it is counting 0 sales and having the value of 1 in aaaTest_CurrFYActive measure/column matrix.

but when the date is in the column value it is counting the 0 sales correctly and there is no value showing for the aaaTest_CurrFYActive measure/column matrix