Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |