Forum Discussion
Assistance Needed - DAX Measure
Hello Guys,
Based on the following data, several visualizations have been created, but how can "Start Date" & "End Date" & "Age of Project" & "Update On" visualizations display N/A when selecting anything from "Project" and "Project Code"？
| Project | Project Code | Status | Start Date(1st Engagement) | End Date(Latest SOW) | Age of Project(in Years) | Updated on |
| A | 22525 | Inactive | 4/1/2019 | 12/31/2022 | 3.50 | 7/25/2022 |
| B | 20870 | Active | 1/1/2019 | 3/1/2025 | 5.00 | 8/7/2024 |
| C | 40525 | Active | 2/11/2019 | 1/1/2025 | 5.00 | 4/9/2024 |
| D | 26101 | Active | 4/9/2014 | 9/30/2026 | 10.00 | 7/9/2024 |
| E | 20430 | Active | 11/3/2015 | 4/30/2027 | 8.00 | 7/9/2024 |
| F | 25085 | Active | 12/18/2019 | 12/31/2024 | 4.00 | 8/5/2024 |
Hi Yaru_828 ,
You can create measures for "Start Date" & "End Date" & "Age of Project" & "Update On" visualizations.
For example,
end date = IF(ISFILTERED('Table'[Project])||ISFILTERED('Table'[Project Code]),"N/A",FORMAT(MAX('Table'[End Date(Latest SOW)]),"mm/dd/yyyy"))When you don't select anything from "Project" and "Project Code", it displayed the date.
When you select something from "Project" and "Project Code", it displayed "N/A".
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Yaru_828 , if the project and selected status have a mismatch it can show N/A.
hello dear, thanks for your resources
Hi Yaru_828 ,
You can create measures for "Start Date" & "End Date" & "Age of Project" & "Update On" visualizations.
For example,
end date = IF(ISFILTERED('Table'[Project])||ISFILTERED('Table'[Project Code]),"N/A",FORMAT(MAX('Table'[End Date(Latest SOW)]),"mm/dd/yyyy"))When you don't select anything from "Project" and "Project Code", it displayed the date.
When you select something from "Project" and "Project Code", it displayed "N/A".
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Stephen, it works
目标：实现不做任何筛选的情况下，某些可视化按固定的要求展示内容
解决方案如下：
end date = IF(ISFILTERED('Table'[Project])||ISFILTERED('Table'[Project Code]),"N/A",FORMAT(MAX('Table'[End Date(Latest SOW)]),"mm/dd/yyyy"))age of project = IF(ISFILTERED('ITO BPO China Program-China'[Project])||ISFILTERED('ITO BPO China Program-China'[Project Code]),SUM('ITO BPO China Program-China'[Age of Project(in Years)]),"N/A")SDM Selection = IF( ISFILTERED('Active Headcount'[Active Project]), SELECTEDVALUE('Active Headcount'[China SDM], "NA"), "NA" )
