SSAS MDX Calculated Members's equivalent in Tabular model

0
votes

I am new in SSAS tabular and need your help. Is it possible and how to write the following MDX statement in DAX :

 CREATE MEMBER CURRENTCUBE.[Measures][Duration none justified]
 AS ([Event][EVT]&[xyz],[Measures][Duration event]),
 FORMAT_STRING = "#" ,
 NON_EMPTY_BEHAVIOR = { [Measures][Duration event] },
 VISIBLE = 1

Thank you for your help

1
ssasdaxtabular
Hello Everyone!! This is old topic but i still looking the answer of my question : CREATE MEMBER CURRENTCUBE.[Measures].[event] AS ([Event TAG].[CODE VT].&[AS],[Measures].[Duration event TAG]) , FORMAT_STRING = "#" , NON_EMPTY_BEHAVIOR = { [Measures].[Duration event TAG] }, VISIBLE = 1; How to write this statement in DAX in SSAS tabular .thank you for you help – dymo

1 Answers

1
votes

Try this solution:

Duration none justified = var __input = calculate(sum([Duration event])
, filter(ALL('Event'[EVT]), 'Event'[EVT] = "xyz")
)

return
if(ISBLANK([Duration event]), BLANK(), __input)