Forum Discussion
Calculation With Multiple Case Statements Over Multiple Tables - Convert SQL to DAX
Great to have help in some ways.
If I answer your question, please mark my post as a solution, this will also help others.
Please give Kudos for support.Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.com
Hi Wildrose
Can you share what is the configuration of the visual you are using?
Slicer
Visual
Type: Matric, Stacked column, table, clustered column
what fields are in the visual
Thank you
Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.com
It is a table. I am trying to add to the above.
Hi Wildrose,
Do you get correct values when you break the calculated measure into two calculated measure and add the line to table?
Tomas
Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.comHi Tomas,
Thank you for all your hints and suggestions. This is what worked. I am grateful for your help.
CALCULATE( SUMX(CUSTOMER_MATERIAL_DAILY_BILLING,'CUSTOMER_MATERIAL_DAILY_BILLING'[ADJ_ITEM_COST_LC_AMOUNT]*CUSTOMER_MATERIAL_DAILY_BILLING[EXCHANGE_RATE]),BILLING_DOCUMENT_LINE_TYPE_REF[BILLING_LINE_ITEM_CATEGORY_CD] IN {"TANN","YBAN","YB1N","RENN","ZGNN","ZLNN"},NOT MATERIAL[MATERIAL_HIERARCHY_LEVEL3_CD] IN {"CH000CH090CH090025"} , NOT SO_DOCUMENT_LINE_TYPE_REF[SO_DOCUMENT_REASON_CD] IN {"Z17","Z18","Z19","Z96","Z97","Z98"})Great to have help in some ways.
If I answer your question, please mark my post as a solution, this will also help others.
Please give Kudos for support.Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.com