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 All,
Trying to achieve same condition in Power BI,Please Help me:
if(Calendar_Week_Relative = 0,
sum({$<$(vSetChart), Stocking_Order_Type={'Outbound'}, Calendar_Week_Relative = {'<=0'}>} Total Total_$(vMeasure)),
sum({$<$(vSetChart), Stocking_Order_Type={'Outbound'}, Calendar_Week_Relative = {'>0<=12'}>} Total_$(vMeasure)))
Solved! Go to Solution.
@Anonymous,
Check measure below and take a look at this article.
Measure 2 = VAR w = SELECTEDVALUE ( Table1[week_relative] ) RETURN IF ( NOT ( ISBLANK ( w ) ) && w = 0, CALCULATE ( [Measure], Table1[week_relative] <= 0 ), [Measure] )
@Anonymous,
You may use SUMX in DAX.
@Anonymous
Could you please provide the screenshots of your sample data and the result you expected?
Thanks & BR
Ryan
Proud to be a Super User!
I don't have any sample data, Here i'm trying to achieve the solution like:
Sample Data:
week_relative: Measure:
-1 10
-2 20
(Blank) 30
0 40
1 50
2 60
Trying to achieve,
if ([Week_relative]=0,
calculate(sum(measure),[week_relative]<=0 I.e. (10+20+30+40),
else show the result as it is
week_relative Measure
1 50
2 60
@Anonymous,
Check measure below and take a look at this article.
Measure 2 = VAR w = SELECTEDVALUE ( Table1[week_relative] ) RETURN IF ( NOT ( ISBLANK ( w ) ) && w = 0, CALCULATE ( [Measure], Table1[week_relative] <= 0 ), [Measure] )
Sam,
It works fine, thnaks muuch for the help!!
Please ignore $(vSetChart) and Total_$(vMeasure), just want to impement If logic to Date dimenssion.
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |