Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |