Forum Discussion

Flo1's avatar
Flo1
Advocate I
4 years ago

Key Influencer Visual displays wrong Factor & Key Influencer Visual shows wrong average

Hello there,

 

I think I have an issue in my Key Influencer Visual. I use the AdventureWorksDW2020 Dataset and try to analyze the Measure Profit and explain it by the factors Product[Subcategory] and Date[Month] (not "Year / Month").

 

(you can download this sample file from my github repository here: https://github.com/FloDBBI/Power-BI-Reports/raw/main/Key%20Influencer%20Visual%20Issue.pbix )

 

The Key Influencer Visual found one factor (Subcategory Mountain Frames) which increase the Profit. But there is another Subcategory which increases Profit more than Mountain Frames: Mountain Bikes (see figure 1).

My first question is: why does the chart show the second factor as the main influencer?

figure 1

 

I have calculated the immediate results of this Key Influencer Visual in a table visual below (figure 2). I have recognized, the calculated average (excluding selected) (-> $2251,11) on the right hand side is not correct (in my opinion), because this is actually the same average value of all subcategories (on the left hand side in figure 1 in orange). The value in the blue circle (in figure 1) is the same I have calculated by myself in column Difference in figure 2 (see blue arrow).

 

 

figure 2

 

My second question is: is the orange average value (calculated by the Key Influencer Visual on the right hand side) correct? It is missleading in my opinion. The correct value should be $1.227,21 (please be not confused by wrong currency €) in the second row of my table visual.

 

Thanks a lot for your help!

Best regards, Flo1.

Need Help

2 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    Hi Flo1 ,

     

    Based on my tests, I don't think there is an error in the calculation. But can you explain the meaning of the following filter condition in the formula?

    'Product'[Subcategory] <>SELECTEDVALUE('Product'[Subcategory])


    Looking forward to your reply.


    Best Regards,
    Henry

     

    • Flo1's avatar
      Flo1
      Advocate I
      4 years ago

      HI v-henryk-mstf,

       

      the complete Measure Expression is

       

      Avg Profit by Month without Subcat =
      VAR _CurrentSubcat = SELECTEDVALUE('Product'[Subcategory])
      VAR _Result =
      AVERAGEX(
      FILTER(ALLSELECTED('Product'[Subcategory]),'Product'[Subcategory] <>_CurrentSubcat),
      [Avg Profit by Month]
      )

      RETURN _Result
       
      I am using this measure to calculate the average Profit for each Product Subcategory. But I want to exclude explicitly one single Subcategory from this calculation. In this case it is the current Subcategory of the initial filter context. In the table above (figure 2) the measure is evaluated for each Subcategory. And I want to exclude the "current Subcategory" from this average calculation. So in row one of the table you see, that -1.300,24 € is the average Profit, if we exclude Subcategory "Mountain Bikes" from this calculation.
       
      Best regards, Flo1.