Tabular Model -Convert MDX to DAX query in Calculations

• Steve Dell

  SSCarpal Tunnel

  Points: 4623

  More actions

  March 7, 2019 at 5:44 am

  #381631

  Hi < 
  I am converting Multidimensional Cubes to Tabular Model in SSAS. 
  I need to convert the calculations as below in MDX to DAX . Can some one suggest some examples or functions?
   Thanks in advance 🙂

  Code :
  case when [Measures].[Complaint]=0 and [Measures].[Received]<>0 then '0'
  when [Measures].[Complaint]<>0 and [Measures].[Received]=0 then '' Else
  ([Measures].[Complaint]/[Measures].[Received])*1000000 END

• Brian Carlson

  SSCarpal Tunnel

  Points: 4170

  More actions

  March 7, 2019 at 6:32 am

  #2023794

  Looks like this would give you the same, except the results are always numeric or blank:

  DIVIDE([Complaint], [Received)*1000000

  If Complaint is 0 it will be 0. If Received is 0 it will be BLANK().