Open Side Menu
Skip to contentBrand Logo
Forums
Inspiration
Ideas
Communities
Blogs
Learning
Support
RegisterSign In
  1. Microsoft Fabric Community
  2. Power BI forums
  3. Galleries
  4. R Script Showcase
Sharon's avatar
Sharon
Microsoft Employee
10 years ago

Association Rules

Description Association rules are ideal to quicly derive insights from large datasets.  The rules are autmatically detected and visualized.    Prerequisites (The sample .pbix files will not...
ScriptInstallPackagesWithWorkaroundsAssorules.R2 KB
Association Rules Showcase_1.0.2.pbix1.1 MB
Advanced Analytics Visualizations
ironryan77's avatar
ironryan77
Kudo Commander
9 years ago

Great job on this visual!  But I can't figure out how you created your dataset?  I'm looking at the sample PBIX file and it looks like the selected fields are total counts.  So in my PBIX file I counted the total values by creating a measure:

MPPL2 = CALCULATE(COUNT(IRC_Metric_RSA_Refresh[PPL2]), FILTER(IRC_Metric_RSA_Refresh, [PPL2]="AUTO"))

 

But when I add this measure to the visual in my own PBIX file, it doesn't allow Basic filtering and it doesn't display in my PBIX.  How can I mimic your behavior in my PBIX file?

ironryan77's avatar
ironryan77
Kudo Commander
9 years ago

Also this is the error I'm getting:

  • boefraty's avatar
    boefraty
    Microsoft Employee
    9 years ago

    Hi ironryan77, 

    Please send me a PBIX, I will see what can be done 

    • ironryan77's avatar
      ironryan77
      Kudo Commander
      9 years ago

      Thanks!

      Association Rules.pbix9.1 MB
      • boefraty's avatar
        boefraty
        Microsoft Employee
        9 years ago

        Hi ironryan77, 

        I am really sorry for late reply :( 

        Apparently some changes/ updates in "arules" package caused the sub-function  "cleanRedundant" to work diffrently without backward compatability.  We will need to solve it both for R visual and R custom visual.  I will update and ping you after update. 

  • © 2026 Microsoft
  • Manage cookies
  • Privacy & cookies
  • Terms of use
  • Trademarks
Your Privacy Choices Consumer Health Privacy