Multiple Case from Tableau to DAX

[Anonymous]

HI,

I have the below in formulas for A and B in Tableau,Parameter need to be defined as A/B.

How can i convert multiple Case from Tableau into DAX.All the columns are in a single Table.

A

CASE [Policy or Risk Survival:]     WHEN 'ABC' THEN SUM([M Count Policy])     WHEN 'EFG' THEN SUM([M Count Item])/SUM([M Count Policy])     WHEN 'IJK' THEN SUM([M EarnedExposure Policy])     WHEN 'LMNO' THEN SUM([M EarnedExposure Item])     WHEN 'PQRST' THEN SUM([M Limit Size])/SUM([M Count Policy])     WHEN 'XYZ' THEN SUM([M Limit Size])/SUM([M Count Item]) END

B

{EXCLUDE [SEQ],[D C Seq Group]:                     CASE [Policy or Risk Survival:]                         WHEN 'ABC' THEN SUM(IF [SEQ]=0 THEN [M Count Policy] END)                         WHEN 'EFG' THEN SUM(IF [SEQ]=0 THEN [M Count Item] END)/SUM(IF [SEQ]=0 THEN [M Count Policy] END)                         WHEN 'IJK' THEN SUM(IF [SEQ]=0 THEN [M EarnedExposure Policy] END)                         WHEN 'LMNO' THEN SUM(IF [SEQ]=0 THEN [M EarnedExposure Item] END)                         WHEN 'PQRST' THEN SUM(IF [SEQ]=0 THEN [M Limit Size] END)/SUM(IF [SEQ]=0 THEN [M Count Policy] END)                         WHEN 'XYZ' THEN SUM(IF [SEQ]=0 THEN [M Limit Size] END)/SUM(IF [SEQ]=0 THEN [M Count Item] END)                     END     } Regards, Raj

[V-lianl-msft]

Hi @Anonymous ,

Can you explain what the measure actually does (for those not familiar with Tableau and please show a sample of your data tables?)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

When i select ABC Policy or Risk Slicer,It should return the 

WHEN 'ABC' THEN SUM([M Count Policy])/

WHEN 'PCS' THEN SUM(IF [SEQ]=0 THEN [M Count Policy] END)

[Greg_Deckler · Accepted solution]

@Anonymous Use a SWITCH statement and you can nest these. Also, be sure you understand how to use SWITCH(TRUE()...) as it is handy although not sure you require it in your circumstance.