Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
FelipMark
Helper II
Helper II

1 Parameter With 2 Measures

Hey guys, I created a parameter to change the visualization of the measures of a table:

TEST PARAMETER = {
("Sales PY", NAMEOF('New Measures' [Sales PY]), 0),
("Sales", NAMEOF('Measures'[Sales]), 1),
("Average Ticket", NAMEOF('Measures'[Average Ticket]),2)
}

However, I want that every time I click on the filter, it returns two measurements.

Ex:
Parameter 1 = Sales + Sales Variation;
Parameter 2 = Sales amount + Amount Variation;
Parameter 3 = average ticket + Ticket Variation;

It is possible??

1 ACCEPTED SOLUTION
olgad
Super User
Super User

Hi, here is a step by step article on how to do it.

You pick in parameter slicer one option but get several columns displayed at a time. Let me know if any questions 

https://www.linkedin.com/pulse/field-parameters-case-measure-groups-olga-dontsova/?trackingId=z1tmg1...

 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

View solution in original post

1 REPLY 1
olgad
Super User
Super User

Hi, here is a step by step article on how to do it.

You pick in parameter slicer one option but get several columns displayed at a time. Let me know if any questions 

https://www.linkedin.com/pulse/field-parameters-case-measure-groups-olga-dontsova/?trackingId=z1tmg1...

 


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.