Forum Discussion

PowerBI_N00b's avatar
PowerBI_N00b
Regular Visitor
3 years ago

Creating a measure to dynamically update as you select

Hi all, noob here but trying to get the hang of things. I am trying to create a measure that when I select an item (or in this example, a name) to view metrics on, it will calculate what "level" the...
Need Help
Tips and Tricks
Tutorial Requests
mike9999's avatar
mike9999
Advocate I
3 years ago

What you are looking for should be do-able in PowerBI.

 

By default, the different tables/slicers/charts are cross-filter the data. So in your example, when you select "Yellow Big Hammer" then the measures will recalculate/any charts with cross-filter.

 

So to do what you need, step 1- make a slicer with the "Name" column of your table.

Step 2- create a relationship between the Level and the table that contains your website view metrics (it needs to have a Level column)

Step 3- create whatever measures are required to interpret the data. you didn't specify what type of aggregations/metrics you are looking for from the website view metrics. it's also possible to aggregate without measures, and chart the website view metrics table directly. 

 

hope that at least helps you get started.

  • PowerBI_N00b's avatar
    PowerBI_N00b
    Regular Visitor
    3 years ago

    Thanks for your help. I think I am half way there. I have the following measure that correctly aggregrates what I am looking for across all levels. How would I modify this to specifically call out the level specific aggegration? I have a few different meaures calculating stuff, this was all just illustrative:

     

    This is the entire event 1 comparison (i modified the original code to fit the description) 

    Overall Level Event 1 calculation = CALCULATE([Event 1 calculation], ALL('Table A'))
     
     
    Using the following for the level(x) calculation, what would I create?
    Levelx Level Event 1 calculation = CALCULATE([Event 1 calculation], ALL('Table A'))
  • PowerBI_N00b's avatar
    PowerBI_N00b
    Regular Visitor
    3 years ago

    I tried the following variation of the formula and got this error: "Cannot convert value 'L1' of type text to type true/false". Any ideas on how to resolve?

     

    Levelx Level Event 1 calculation = CALCULATE([Event 1 calculation], TableA[LEVEL])