cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
einarrattgard
Helper III
Helper III

Filtering Measures

Hello!

I have created lots of measures and I want to make an "Executive Summary"-Page where you can pick one of the measures and see in all graphs. For this, my plan was to make a table like this:

 

Table of Measures = 
{
    ("Inventories", [Days Inventory Outstanding Deliveries]),
    ("Availability", [Availability %]),
    ("Broken Promises", [Broken Promises %]),
    ("Accidents", [Accidents per 100 Employees]),
    ("Capacity Utilization", [Capacity Utilization %]),
    ("MCLI",[MCLI]),
    ("Productivity",[Productivity]),
    ("Flexibility",[Flexibility Index])
}

 

But all of the measures are dependant on that you pick a certain time period. Is there a way for me to copy a column from a table and then add this code to each row in that column?
Like this:

einarrattgard_0-1626079214506.png

 

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@einarrattgard , do you need a measure slicer? This means if select measure A from slicer visual/s will display Measure A, if select Measure B that will be displayed

 

if yes refer

measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

 

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

1 REPLY 1
amitchandak
Super User IV
Super User IV

@einarrattgard , do you need a measure slicer? This means if select measure A from slicer visual/s will display Measure A, if select Measure B that will be displayed

 

if yes refer

measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

 

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors