How to analyze a categorical metric with Key Influencer Visual despite disabled implicit measures

[xChillout]

I would like to use the Key Influencer Visual to analyze a text column as categorical metric as described in the official documentation (Analyze a metric that is categorical).

However, since I have calculation groups in my model, implicit measures are disabled by design which leads to the Key Influencer Visual not accepting a text column as metric to be analyzed. 

The error message suggest to use a measure. But so far I havent been able to come up with a measure  (or any other solution) to make the analysis work as intended (= the way it is shown in the documention).

The following files should be accessible using the following OneDrive link: PBI_KeyInf_customerfeedback

1. Keylnf_customerfeedback_noCG.pbix
   • added Key Influencer Viz with 'Customer Table'[Rating] as categorical metric in 'Analyze' to the original sample file from the documentation
2. Keylnf_customerfeedback_withCG.pbix
   • added a Calculation Group 'CG_Test' to the model for testing purposes to file Keylnf_customerfeedback_noCG.pbix
   • Viz stops working

[v-hashadapu]

Hi @xChillout , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[v-hashadapu]

Hi @xChillout , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[v-hashadapu]

Hi @xChillout , Thank you for reaching out to the Microsoft Community Forum.

You're running into this issue because when you add calculation groups to your model, implicit measures like using a text column directly in the Analyze field are disabled. The Key Influencer visual depends on implicit measures to analyze raw categorical fields like your Rating column, so once calculation groups are introduced, Power BI expects an explicit measure instead.

To get things working again and still analyze something like “what factors make a Low rating more likely?”, you’ll need to create a new measure that acts as a binary flag, something Power BI can sum or average across rows.

Try below:

DAX

CopyEdit

Low Rating Flag =

CALCULATE(

    SUMX(

        'Customer Table',

        IF('Customer Table'[Rating] = "Low", 1, 0)

    )

)

Put this measure into the Analyze field of the Key Influencer visual. Add fields like Country-Region or others into the Explain by section.

If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.

[v-hashadapu]

Hi @xChillout , Thank you for reaching out to the Microsoft Community Forum.

Please let us know if your issue is solved. If it is, consider marking the answers that helped 'Accept as Solution', so others with similar queries can find them easily. If not, please share the details.
Thank you.

[xChillout]

@danextian @TomMartens 
Thank you very much for engaging.

I have updated my original post with a link to sample files. @danextian in the original working file there is no aggregation/summarization set for the column. is that what you meant?

[danextian]

Hi @xChillout

Prior to creating calculation groups, what aggregation did you use for the text columns? That must be recreated using a measure.

[TomMartens]

Hey @xChillout ,

please consider creating a pbix containing sample data that still reflects your semantic model (tables, relationships, calculated columns, and measures). Upload the pbix to OneDrive, Google Drive, or Dropbox and share the link.

Regards,

Tom