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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Praj8050
Helper I
Helper I

Using Parameters in Dax calculation

Hello Community,

I am facing a challenge while trying to extract specific text from multiple category fields using DAX calculations 

Here's the situation:

I have a table with the following structure:

img5.PNG



My goal is to extract the text "Late" or "Early" from any of the categories (Category1, Category2, Category3, or Category4). I can successfully do this with individual column using a direct formula such as:

DAX
= IF(CONTAINSSTRING([Category1], "Late"), "Late", "Early")

However, I want to make this dynamic by using a parameter so that I can choose any category to extract the text from. For this purpose, I created a parameter (named `Parameter Selection`) for Category1, Category2, Category3, and Category4. My intention is to use the following formula to determine the text based on the selected category:

DAX
= IF(CONTAINSSTRING(['Parameter Selection`], "Late"), "Late", "Early")

Unfortunately, when I use this formula with the parameter, I encounter the following error:


imp6.PNG

 

Questions:
1. How can I resolve the error related to field relationships?
2. Is there a specific way to set up parameters in DAX calculations to avoid such issues?
3. What is the best approach to dynamically extract text like "Late" or "Early" from selected categories using parameters?

Any guidance or suggestions to solve this problem would be greatly appreciated.

Thank you for your help!

 

2 REPLIES 2
Praj8050
Helper I
Helper I

Hi

My requirement differs slightly: depending on the selected category, the output should display "Late" or "Early" for each value within that chosen category.
Ex

6.png

Rakesh1705
Super User
Super User

Hi first prepare measures for each category like the following

Rakesh1705_0-1720098446229.png

 

Create one parameter table

Rakesh1705_1-1720098509576.png

use the same parameter as slicer and part of the output table

 

Rakesh1705_2-1720098569916.png


If the above meets your requirement then pls accept the same as your solution.

 



Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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