So our corporate dataset get info from SAP, Project Online (PO) and several other sources, via Direct Query. These 'base' tables (26 of them) are not modifiable by us general users, and if the right measure/variable is created it shouldn't need to be.
I work in the Risk, Issues and Lesions Learned area, and general support for the PMO. Am trying to finalise a visual (currently a matrix) that shows PM's the items that fail meeting corporate requirements, so they can remediate the issue, and also items that are 'well maybe you should look at this?' (i.e. Risks that have not been modified in PO for a 'time' based on rating). All these measures seem to be working fine and genjerally look something like:
2.11-No Treatment date = CALCULATE(COUNTROWS(Risk),isblank(Risk[Treatment Due Date]),Risk[Risk Status]="(1) Active",Risk[Risk Rating (Current) Score]>8)+0
or "# Projects =CALCULATE(DISTINCTCOUNT(Project[Project ID]),Project[Is Archived]=FALSE)+0"
What I cannot get to work properly is a method to display the projects that do not have risks, as the 'Risk' entry in the Risk table only exist when created.
I am sure I am missing a easy way to do this, and add the projects that do not have risks to the matrix currently organised by PM/Project/Risk Title.
Anyone have a idea on what I am missing? I can count the number associated to projects when there, but how to 'Count' the absence of something? (i.e. 'NULL' or 'ISBLANK' doesn't do it)
