DAX (Filter Higher Percentage of each product and its Class)

srehman

Board Regular
Joined
Jan 4, 2020
Messages
178
Office Version
  1. 2016
Platform
  1. Windows
Hi Team,
The aim is to check higher percentage of each SKU from (% RT Cummul) columns which is derived from DAX measure, & class by condi is calculated condition column.

I have tried RANKX , MAX formulas but not giving me correct result.

Happy to provide you more details.

Any thoughts

Class by Condi -->Calculated Conditional Column% of RT Cummul--> DAX Measure



Max Percent 1.csv
ABCDEFGHI
1
2SKUClass by Condi% of RT CummulSKUResult
310040620D100%10040620D
410052900B100%10052900B
510080560D100%10080560D
610080570A22%10080570AA
710080570AA44%10080620A
810080570B33%10110270B
910080620A92%10120320C
1010080620AA8%10125850B
1110110270B100%10126250A
1210120320B33%
1310120320C67%
1410125850B100%
1510126250A65%
1610126250B35%
17
18
Sheet1
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Watch MrExcel Video

Forum statistics

Threads
1,123,493
Messages
5,601,998
Members
414,490
Latest member
Rip181

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top