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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
aprilbanana
New Member

DAX to switch value based on selected value

Hello,

 

How do I switch a value in a different column based on the selected value in my dropdown?

For example:

NameResult
Banana0
Grape0
Strawberry 1

Apple

0

 

When i get the average of the result column it'll be 25%. If I choose Banana from my slicer, how do I get it to change the result column to 1?

Results should be: 

NameResult
Banana1
Grape0
Strawberry 1
Apple0

 

New average should bt 50%.

1 REPLY 1
bhanu_gautam
Super User
Super User

Hi @aprilbanana , you can achieve this by using parameters in Power BI

Paramaters can be found under Modelling tab and you can use numeric range and use that in your DAX

bhanu_gautam_1-1707756562579.png

 




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.