Forum Discussion

mkatsubl1's avatar
mkatsubl1
New Member
4 years ago
Solved

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

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
 
 
 
 

 

Need Help
  • RayWu's avatar
    RayWu
    4 years ago

    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

1 Reply

  • RayWu's avatar
    RayWu
    Icon for Memorable Member rankMemorable Member
    4 years ago

    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