Forum Discussion

sanrajbhar's avatar
sanrajbhar
Frequent Visitor
5 years ago
Solved

Scatter plot's X axis value based on slicer/filter value pick value calculation?

Hello Commnunity,   is there any way to create scatter plot with x-axis value being dyanmic taking value and multplying from selected pick value(filter)? e,g See below Snapshot, I am unpivoting th...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, sanrajbhar 

    You can try to store the factor in a variable to check if it works

     

     

    Measure = 
VAR factor =
    SELECTEDVALUE ( N95_factor[Factor] )
RETURN
    SUMX (
        Table1,
        IF ( Table1[Attribute] = "N95", Table1[Value] * factor, Table1[Value] )
    )

     

     

     

    If it doesn't meet your requirement,please provide more details about it .It you can share a sample pbix file,it will better help us for testing.

     

    Best Regards,
    Community Support Team _ Eason

sanrajbhar's avatar
sanrajbhar
Frequent Visitor
5 years ago

hi,

Table1[Atrribute] is not value column , it hold string. 

calcDax = SUMX(Table1,IF(Table1[Attribute]="N95",Table1[Value]*SELECTEDVALUE(N95_factor[N95f_val]),Table1[Value]))

I want to match string rowise  if  Table1[Attribute] = "N95 " then do multiple by factor selected in pick box otherwise use the original value. Abox Dax is working in good simple dummy data. but not on actual data. it multiple strangly like, 7 * 6 = 714.

 

I am not sure whats goes wrong.?