Forum Discussion

Eyal's avatar
Eyal
Helper II
7 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    7 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