Matrix : Do not display the other values that don't match the filter

[jerpic]

Hello,

I have this matrix.

built with that parameters :

I would like to show only the skills that match a specific value, for that I applied a filter on the "Min de RATING" like that.

As result, I got that one : 

I would like to get as result that display.

USER	SKILL 1	SKILL 2	SKILL 3
USER 1	1
USER 2			1
USER 3	1	1
USER 4		1	1

Any help would be very appreciated.

Best Regards,

[v-yangliu-msft · Accepted solution]

Hi  @jerpic ,

Here are the steps you can follow：

1. Create measure.

Flag =
IF(
    MIN('TBL_SKILL_NEW'[RATING])=1,MIN('TBL_SKILL_NEW'[RATING]),BLANK())

2. Result:

Best Regards,

Liu Yang

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

[amitchandak]

@jerpic , A simple measure like this

Measure = CALCULATE(min(TBL_SKILL_NEW[RATING]), FILTER(TBL_SKILL_NEW,TBL_SKILL_NEW[RATING] =1))

Find file attached after signature

[amitchandak]

@jerpic , Try a measure like 

maxx(filter(ADDCOLUMNS(summarize(Table, Table[User], Table[skill]), "_1",[Min De Rank]), [_1] =1),[_1] )

[jerpic]

Hi @amitchandak 

Thanks for your quick reply. Unfortunately, I'm not sure how to use it...

If you can look at my file, it would be nice : PBIX 

Best Regards,