Forum Discussion
dmytro_po
8 years agoFrequent Visitor
Calculate the most common cost
Greetings, please help to write a measure that calculates the most common cost for each product.
- 8 years ago
Try this:
First a measure to count rows.
NoRows = COUNTROWS(Data)
Then figure out the most common cost. The FIRSTNONBLANK deals with ties, without it you will get an error in the precense of the two (or more) cost values being most common.
MostCommonCost = FIRSTNONBLANK( TOPN( 1, VALUES(Data[Cost]), RANKX(ALL(Data[Cost]),[NoRows],,ASC) ), 1 )That should do it.
dmytro_po
8 years agoFrequent Visitor
Anonymous, you missed a closing parenthesis:
ALL('Datos Numericos'[1.PST Compromiso]
ALL('Datos Numericos'[1.PST Compromiso]
Anonymous
8 years agoNot applicable
A silly mistake on my part... It works fine now! Thank you!