Forum Discussion

jgap98's avatar
jgap98
Regular Visitor
3 years ago

Competitiveness index

Hi all,    I'm having some trouble with the Dax logic. I have a data set, which I don't have access right now, but the structure is simple:   Data - product ID - product description - brand - pai...
average
CALCULATE
Indexes
relativity
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

jgap98 , Based on what I got  measure like

 

Calculate( calculate(Averagex(Values(Table[Brand]) , calculate(Average(Table[Price]) ) )

, allselected())

 

or

 

calculate(

calculate(Averagex(Values(Table[Brand]) , calculate(Average(Table[Price]), filter(Table[Brand] <>Max(Table[Brand] ) )

, allselected())