Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi guys, I need some help with creating a DAX function to retract all the project names.
The data model is shown below like this:
For the dashboard:
The dashboard looks like this:
Need help with:
I am having difficulties writing a DAX to extract a list(column) of all the project names in the same postcode.
The DAX should overwrite the existing report-level filters so that all companies' projects can be shown in the list/column. As long as the project is located within the post-code, it will be shown.
The DAX function I came up with is not working as expected, and I've been struggling with this question for days. Your help would be really appreciated.
Solved! Go to Solution.
Hi @yephome_phoenix ,
OK, you want a list of all the project name which company is localed in the post-code ignore page-level filter.
surrounding projects = CALCULATETABLE(values('project'[name]),FILTER(All('project'), 'project'[post_code] = [current post code]) , 'project'[status] = 1)
If you want keep some filter on the page-level, for example, project status. Then ALLEXCEPT('project', porject[status])
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @yephome_phoenix ,
OK, you want a list of all the project name which company is localed in the post-code ignore page-level filter.
surrounding projects = CALCULATETABLE(values('project'[name]),FILTER(All('project'), 'project'[post_code] = [current post code]) , 'project'[status] = 1)
If you want keep some filter on the page-level, for example, project status. Then ALLEXCEPT('project', porject[status])
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
can someone please help : (
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
46 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |