Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Solved! Go to 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
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
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
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
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
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
It worked! Thats a great Help! Thanks again ..
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
78 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
61 | |
60 |