Filter a matrix visual with values of measure

[psorel]

Hi, 
I created a matrix visual with differents groups in first column and count and sum measures after. 
I don't understand why i can't filter on measure >0 for delete rows with 0. 
I tried a "test_filter" measure if( [nb noubeaux mandats] >0,1,0) i got 0 everywhere. 
I don't have all or allexcept functions in measures.
Can u help me ?


 

[psorel]

In my case it's a measure for each column and different data type, can i filter all the row if just one value  " [nb noubeaux mandats" in my case , is > 0 .  I filter all my measure on the max(start month date) . Thanks

[Laxmanjatoth]

are you using any time intelligence functions or anythink else ?

[danextian]

Hi @psorel 

That is because the filter is applied to the total column and not to every cell in your matrix. In the screenshot below, Table2 is filtered to have a value  > 0 but it did not filter out the second row because the total for that row is 2 and not 0

If you want those  with 0 disappear, return them as blank in a measure

My Measure =
VAR _val = SUM ( 'Table'[Value] ) RETURN IF ( _val = 0, BLANK (), _val )

[Anonymous]

Hello,danextian and Laxmanjatoth ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.
Hi,@psorel .I am glad to help you.
Like this?

Note that I didn't put any fields in the Columns field, the Rows filed puts the [ID] column, and the Values field puts the measure of the data being displayed.

This is my test data:

the measure I create.

M_DateDiff = 
VAR _date =MAX('matrixTest'[Date])
VAR _maxTotal =CALCULATE(MAX('matrixTest'[Date]),ALL(matrixTest))
RETURN
DATEDIFF(_date,_maxTotal,DAY)

M_MaxGroupName = MAX('matrixTest'[GroupName])

M_SumSales = SUM('matrixTest'[DailySales])

test_filter = IF([M_SumSales] > 0 ,1,0)

If my understanding is off, please keep me informed and attach more information or provide the pbix test file (shared on the forum via a github link) that doesn't contain sensitive data This will help to resolve your issue.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[danextian]

That will work with matrix without a field on the columns tile. Following that approach, OP might as well use a table instead of a matrix. But, what if  for example, ID 1 has both A and B? Since GroupName value is being returned using a measure using MAX, A now disappears.

[Anonymous]

Hi,@danextian .
Thank you very much for the heads up.