Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
I am trying to use a parameter within a filter statement, but no matter what I try I just cannot get it to work. I'm clearly doing something wrong, but would be grateful if someone can point out what!
var planned = SUMX(FILTER(sprint_status_summary,
sprint_status_summary[sprint_id] = sprint_summary[sprint_id]
&& sprint_status_summary[project_key] = sprint_summary[project_key]
&& sprint_status_summary[start_status] IN VALUES(paramUnreleasedStatus)),
// && CONTAINSROW({"Ready For Live","Release Test"}, sprint_status_summary[start_status])),
//&& IF(CONTAINSROW(paramUnreleasedStatus, sprint_status_summary[start_status]),TRUE(),FALSE())),
sprint_status_summary[story_points])
Solved! Go to Solution.
Thanks for the reply from bhanu_gautam , please allow me to provide another insight:
Hi @chipchidster ,
Is the paramUnreleasedStatus you are referring to the Manage Parameters created in the Power Query?
Check the parameter - Enable load - load to table
You can try the following dax:
Test =
SUMX(
FILTER(ALL('sprint_status_summary'),
'sprint_status_summary'[sprint_id]=EARLIER('sprint_status_summary'[sprint_id])&&
'sprint_status_summary'[start_status] in
SELECTCOLUMNS('paramUnreleasedStatus',"Ready For Live",[paramUnreleasedStatus])),[story_points])
If the results above don't match your expected results, you can express your expected results in the form of a picture and we can help you better!
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply from bhanu_gautam , please allow me to provide another insight:
Hi @chipchidster ,
Is the paramUnreleasedStatus you are referring to the Manage Parameters created in the Power Query?
Check the parameter - Enable load - load to table
You can try the following dax:
Test =
SUMX(
FILTER(ALL('sprint_status_summary'),
'sprint_status_summary'[sprint_id]=EARLIER('sprint_status_summary'[sprint_id])&&
'sprint_status_summary'[start_status] in
SELECTCOLUMNS('paramUnreleasedStatus',"Ready For Live",[paramUnreleasedStatus])),[story_points])
If the results above don't match your expected results, you can express your expected results in the form of a picture and we can help you better!
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@chipchidster , Try using
dax
var planned = SUMX(
FILTER(
sprint_status_summary,
sprint_status_summary[sprint_id] = sprint_summary[sprint_id]
&& sprint_status_summary[project_key] = sprint_summary[project_key]
&& sprint_status_summary[start_status] IN VALUES(paramUnreleasedStatus)
),
sprint_status_summary[story_points]
)
Proud to be a Super User! |
|
Hi Bhanu - I am already trying that logic on line 4 of the example
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
8 |