Forum Discussion
Solved
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 an...
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.
目标：实现不做任何筛选的情况下，某些可视化按固定的要求展示内容
解决方案如下：
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" )