cancel
Showing results for
Did you mean: Regular Visitor

## Multiple Case from Tableau to DAX

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
1 ACCEPTED SOLUTION  Super User

@Rtum 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.

Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
Check out my latest book!  3 REPLIES 3  Community Support

Hi @Rtum ,

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. Regular Visitor

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)  Super User

@Rtum 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.

Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
Check out my latest book!     