Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Solved! Go to 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.
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.
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)
@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.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |