Forum Discussion
Memory error when using rank formula
I have a measure "App version sorted Total Duitable Shpmts Col", and for each unique [ecom source name] which is a column, there is a number in the measure. I want to display the [ecom sour...
1. Create a measure to find Maximum of measure.
Most used App Version Total Duitable Shpmts = MAXX(ALLSELECTED('CIN Data Quality'),[App Version Sorted Total Duitable Shpmts Col])2. Create another measure to find [ecom source name] value when measure = maximum value above.
Most used App Version = CALCULATE(MAX([Ecom Source Name]), FILTER(allselected('CIN Data Quality'),[App Version Sorted Total Duitable Shpmts Col]=[Most used App Version Total Duitable Shpmts]))
1. Create a measure to find Maximum of measure.
Most used App Version Total Duitable Shpmts = MAXX(ALLSELECTED('CIN Data Quality'),[App Version Sorted Total Duitable Shpmts Col])
2. Create another measure to find [ecom source name] value when measure = maximum value above.
Most used App Version =
CALCULATE(MAX([Ecom Source Name]), FILTER(allselected('CIN Data Quality'),[App Version Sorted Total Duitable Shpmts Col]=[Most used App Version Total Duitable Shpmts]))