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
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
Solved! Go to Solution.
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
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
Any idea what will be correct dax
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
108 | |
102 | |
94 | |
71 |
User | Count |
---|---|
173 | |
134 | |
132 | |
102 | |
95 |