Remove BLANK rows from Matrix which has full of Measures

[tps136]

Hi All,

I've a Matrix that has full of Mesaures grouped by Items, Price. In a specific measure I have blank rows. I need them to hide,

any help please?

Result that i am getting now,

Item     Price     Sell%     Totalamt     TotUnits

101       $106      61%       $10,000        500

102       $211      55%       $12,500        750

103       $099                    $10,345        325

104       $345                    $16,111        720

Result I want is just first 2 rows,

Item     Price     Sell%     Totalamt     TotUnits

101       $106      61%       $10,000        500

102       $211      55%       $12,500        750

DAX

Sales Rank Desc = RANKX(ALL(Sheet1[Item], Sheet1[Price]),[Total Sell%],,DESC)

Sell% = IF([Sales Rank Desc] <= [SelectedTopNValue],[Total Sell%], BLANK())

Thanks is advance! SenSam

[Thejeswar · Accepted solution]

Hi @tps136,

You can just add in Visual Filters of that Visual, as "is not blank".

That would satisy your requirement. Same is shown below

The First Visual shows the full data while the second visual has Visual Filters applied to it

First Visual is simply full data display and the second visual is having Visual Filters applied

[Anonymous]

I have a Matrix that has total coming from backend. when i use that field matrix give me sum of rows which i need to get rid

this is the data

Which delivery name is blank this is the main project value

so when i use matris its giving me like this which wrong

2880 is the correct value but when i do sum its include i need exclude that value

[Thejeswar · Accepted solution]

Hi @tps136,

You can just add in Visual Filters of that Visual, as "is not blank".

That would satisy your requirement. Same is shown below

The First Visual shows the full data while the second visual has Visual Filters applied to it

First Visual is simply full data display and the second visual is having Visual Filters applied

[tps136]

Wow! Fantastic!  Thanks a lot.

One more request need your help. I've sell%  --> 65% that comes twice for 2 different items. while displaying  top3 I should have  4 rows counting 65% as one of the top.

Result that i am getting now [when i select top3]

Item     Price     Sell%     Totalamt     TotUnits

101       $106      61%       $10,000        500

102       $211      61%       $12,500        750

103       $099      55%       $10,345        325

Expected Result: [First 2 rows considred as top = 1, 2rd row = top2, 3rd row being top3]

Item     Price     Sell%     Totalamt     TotUnits

101       $106      61%       $10,000        500

102       $211      61%       $12,500        750

103       $099      55%       $10,345        325

104       $345      52%       $16,111        720

[Thejeswar · Accepted solution]

Hi @tps136,

I think you should modify your RANKX DAX a bit at the end

The Same is shown below.

Sales Rank Desc = RANKX(ALL(Sheet1[Item], Sheet1[Price]),[Total Sell%],,DESC, DENSE)

This should bring in the other record as well

[tps136]

It worked! Thats a great Help! Thanks again ..