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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
mdaamirkhan
Post Prodigy
Post Prodigy

Switch Case not working

Hi All,

 

I have need help in my Dax query below  which I have highlighted in red is not returning any value in that table

Can you help me on dax 

Selected Time Period =
VAR CurrentItem = SELECTEDVALUE( 'Time Period'[ID])
VAR CurrentItem_ = SELECTEDVALUE('wt_fin_staging pl_sorting'[Account_ (Normalized)])
RETURN
SWITCH( TRUE(),
CurrentItem_ = "Other staff costs",CALCULATE([Total Actual],FILTER(wt_fin_pl_actuals_monthly_summary,wt_fin_pl_actuals_monthly_summary[account_description] = CurrentItem_)),
CurrentItem = 1, TOTALMTD([Total Actual],'wt_fin_staging dim_date'[date].[Date]),
CurrentItem = 2, TOTALQTD([Total Actual],'wt_fin_staging dim_date'[date].[Date]),
CurrentItem = 3, [Total Actual],
CurrentItem = 4, TOTALYTD([Total Actual],'wt_fin_staging dim_date'[date].[Date])
)
Screenshot 2022-08-09 002455.png

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @mdaamirkhan ,

 

Please try to separate this part separately to test whether the result is returned.

Selected Time Period =
VAR CurrentItem_ = SELECTEDVALUE('wt_fin_staging pl_sorting'[Account_ (Normalized)])
RETURN
SWITCH( TRUE(),
CurrentItem_ = "Other staff costs",CALCULATE([Total Actual],FILTER(wt_fin_pl_actuals_monthly_summary,wt_fin_pl_actuals_monthly_summary[account_description] = CurrentItem_)))

 

Best Regards,

ShundaSteph

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @mdaamirkhan ,

 

Please try to separate this part separately to test whether the result is returned.

Selected Time Period =
VAR CurrentItem_ = SELECTEDVALUE('wt_fin_staging pl_sorting'[Account_ (Normalized)])
RETURN
SWITCH( TRUE(),
CurrentItem_ = "Other staff costs",CALCULATE([Total Actual],FILTER(wt_fin_pl_actuals_monthly_summary,wt_fin_pl_actuals_monthly_summary[account_description] = CurrentItem_)))

 

Best Regards,

ShundaSteph

mdaamirkhan
Post Prodigy
Post Prodigy

Any idea what will be correct dax 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.