Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |