Help me translate this MDX into DAX for creating a measure in power BI.

[Amitg_4890]

1. 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.

[adudani]

HI @Amitg_4890 ,

to my understanding: there are 2 measures in the cube called " Employee Time" and "Employee Count Time"

essentially

format(

if (

[Employee Time]= 0, blank() --null,

[Employee Time]/ [Employee Time Count] / 364.25
),

int
)

the above is then dax translation.

If you provide more information on the measures, we could create variables to add on the code and get the output.

Appreciate a thumbs up if this helps.

let me know if this resolves the question.

[Amitg_4890]

omg thank you very much for the response! 

And there's only employee time, nothing like employee count time but count is an aggregation which was used, I believe. Something like count(employee time).