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.