Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Need Help in Calculated row in matrix

Used this DAX in aboveWhatsApp Image 2023-11-10 at 13.39.46_753dcd94.jpg---

RatioCos2 =
DIVIDE (
CALCULATE (
SUM('Table2'[Amount USD])/1000000,
ALL(Table2),
ALL ( 'Classification2' ),
'Classification2'[Account] = "Services Orders"
),
CALCULATE (
SUM('Table2'[Amount USD])/1000000,
ALL(Table2),
ALL ( 'Classification2'),
'Classification2'[Account] = "Total Orders"
    )
)*100

 

SumAndRatio2 =
VAR varClassification = UPPER(IF(HASONEVALUE(Classification2[Account]),VALUES(Classification2[Account]),BLANK()))
RETURN
SWITCH(varClassification,"Services Orders %",[RatioCos2],[RegularSum2])

When i am adding Date Column, the "Service Orders %" row is not showing. as in above its showing..!

 

WhatsApp Image 2023-11-10 at 13.42.56_7e7753f1.jpg

Status: Investigating
Comments
Anonymous
Not applicable

Hi @shivam_s001 ,

 

I think this error may be due to context, try changing ALL('table') to ALLEXCEPT('table','table'[Services Orders %]).If the problem persists, please provide me with samples that map the structure of your data.

 

Best regards,
Community Support Team_ Scott Chang