Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Hi Experts
I need a if condition with a selected value in DAX.
So if the user does not selects a Region then
Contribution Margin =
VAR Mth1 =
SELECTEDVALUE ( SelMth_Current[Month] )
VAR yr =
SELECTEDVALUE ( SelYr[Year] )
VAR Reg =
SELECTEDVALUE (Region_Grp[Region])
VAR Fcst1 =
SELECTEDVALUE ( SelMth4[Actual] )
VAR Prod =
SELECTEDVALUE(Product_Grp[Product])
VAR MthVal =
CALCULATE (
SUM ( Profitability_Consolidation[Profit] ),
Profitability_Consolidation[Period] = Fcst1,
Profitability_Consolidation[Month] = Mth1,
Profitability_Consolidation[Year] = yr,
Profitability_Consolidation[Product] = Prod,
Profitability_Consolidation[Region] = Reg,
Profitability_Consolidation[AccountGroup] ="Contribution Margin"
)
RETURN
MthVal/1000
Other wise blank
Solved! Go to Solution.
@Anonymous , I remove all filters and added them one by one
When I add this one not getting value. I have filer from you other ticket
Profitability_Consolidation[Year] = yr
Please check the value for this
@Anonymous , I remove all filters and added them one by one
When I add this one not getting value. I have filer from you other ticket
Profitability_Consolidation[Year] = yr
Please check the value for this
Posted to wrong question
Thanks- got it...
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
71 | |
68 | |
42 | |
42 |
User | Count |
---|---|
46 | |
40 | |
28 | |
27 | |
26 |