How to count (and display) Projects (its own table) that do not have 'x' (from one of several tables
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)
Help me translate this MDX into DAX for creating a measure in power BI.
Hey there, please help me translate this MDX into DAX for creating a measure in power BI. I am new in Power BI and I was assigned to translate this MDX script to create measure in power BI. The MDX is as follows; CREATE MEMBER CURRENTCUBE.[Measures].[EmT] AS IIF(([Units Of Measure].[UoM Code].&[0/EmT],[Measures].[Employee Time])=0.0,NULL,([Units Of Measure].[UoM Code].&[0/Emt],[Measures].[Employee Time])/([Units Of Measure].[UoM Code].&[0/EmT],[Measures].[Employee Time Count])/365.25), FORMAT_STRING = "#,##0.0", VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'Employees'; I have "unitsofmeasures" table and "UoM code" field inside it already. It's just that MDX I can't seem to translate.
Slicer DAX
1) I am trying to get all my options in the slicer to show values. Currently, I can only see values in the cluster column visual for “Y”: 2) If I click to “W” or “Q” or “M” no values show up in the chart: 3) I have looked at the DAX for the measure “QTY Total” that is used for the chart: 4) In my journey to find a solution, I changed the last portion of the DAX by replacing ‘Calendar’[Year] with [Month]: 5) With the change, the values for “Y” and "M" appears in the clustered columns visual - but nothing for “Q” or “W" 6) How can I modify the DAX to include "Y", "M", "Q" and "W"? Any help would be appreciated: https://www.dropbox.com/s/f3hh4vzkkiz0agv/ScooterWorld.pbix?dl=0
