Key Influencers Visual but it doesn't seem to work with Measures

[mkatsubl1]

Hi all,

I trying to use the Key Influencers Visual but it doesn't seem to work with Measures... I have a measure that SUMs a column depending on a slicer and it doesn't seem to work (always fails) but if I simply add the specific table column it works.. Post if you know anything thanks!

The measures I use is the following:

Real] =
SWITCH(SELECTEDVALUE(Metrics[id]),
    1, [Total Sales]
    2, [Total Costs]
    3, [Total Quantity]
)

[Total Sales] = 
CALCULATE(
    SUM(Sales[Total Sales]),
    Sales[Value Type] == "Sales"
)

If i simply drag the Sales[Total Sales] Column to the Visual it works... but the measure doesnt

[ray_ux · Accepted solution]

@mkatsubl1 

It works with a switch/slicer and a measure, it would be due to the way it's aggregating, you could probably achieve the same by pulling your primary key into the 'expand by' field.  Additionally, you can see the issue by turning it into a table.

Linear regression wants lots of a data-points in order to do its calculation