Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Used this DAX in above---
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..!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.