Forum Discussion
Eyal
7 years agoHelper II
Scatter plots from atributes
Hi, I have a a large data set, arrange as a flat table that iI use to control trends from diffrent attributes. I want to creat a scatter plot to see the correlation between the attributes but c...
- Anonymous7 years ago
HI Eyal ,
You can try to use following measures:
HeightM= CALCULATE ( MAX ( Table[Value] ), FILTER ( ALLSELECTED ( Table ), [Attribute] = "Hight" ), VALUES ( Table[Lot] ) ) PriceM = CALCULATE ( MAX ( Table[Value] ), FILTER ( ALLSELECTED ( Table ), [Attribute] = "Price" ), VALUES ( Table[Lot] ) )Regards,
Xiaoxin Sheng
Anonymous
7 years agoNot applicable
HI Eyal ,
You can try to use following measures:
HeightM=
CALCULATE (
MAX ( Table[Value] ),
FILTER ( ALLSELECTED ( Table ), [Attribute] = "Hight" ),
VALUES ( Table[Lot] )
)
PriceM =
CALCULATE (
MAX ( Table[Value] ),
FILTER ( ALLSELECTED ( Table ), [Attribute] = "Price" ),
VALUES ( Table[Lot] )
)
Regards,
Xiaoxin Sheng
Eyal
7 years agoHelper II
Anonymous
Thank you very much, work very welll.
Eyal