Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm strugling to create cumulative line. I know how to do in theory but I'm stuck on one of the steps. I can't use measure in calculation and I don't know how to convert this.
This is what I have:
I have create 3 measure:
Dane_1 - CALCULATE (COUNTROWS (Tracker),FILTER (Tracker,Tracker[PIF Status]="COMPLETED"&& Tracker[Type]="other"))
Dane_2 - CALCULATE (COUNTROWS (Tracker),FILTER (Tracker,Tracker[PIF Status]="IN PROGRESS"&& Tracker[Type]="other"&& Tracker[Group from MDS]<>"5"&&Tracker[Group from MDS]<>"4"))
Dane_suma - Dane_1 + Dane_2
The 3rd I want to use to create cumulative line.
I try to use such code but i can't use measue inside calculation 😐
Solved! Go to Solution.
Maybe this? :
Skumulowany =
SUMX (
FILTER ( ALLSELECTED ( Tracker ), Tracker[RFS week] <= max(Tracker[RFS week]) ),
[Dane_suma]
)
_______________
If I helped, please accept the solution and give kudos! 😀
@Cosik ,
Please try like
Skumulowany =
CALCULATE (
SUM(Tracker[Dane_suma]),
FILTER(
ALLSELECTED(Tracker),
Tracker[RFS week]<=max(Tracker[RFS week])))
Refer this file, how to do week calculation using week rank: https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0
I have the same error as above.
Maybe I have something wrong im my measure.
Hi Cosik,
Try SUMX function:
Skumulowany =
SUMX (
FILTER ( ALLSELECTED ( Tracker ), Tracker[RFS week] <= Tracker[RFS week] ),
SUM ( Tracker[Dane_suma] )
)
_______________
If I helped, please accept the solution and give kudos! 😀
I have error.
The "Dane_suma" can't be found in "Tracker" table or you can't use it here.
Sure, because it is a measure and should be like this:
Skumulowany =
SUMX (
FILTER ( ALLSELECTED ( Tracker ), Tracker[RFS week] <= Tracker[RFS week] ),
[Dane_suma]
)
_______________
If I helped, please accept the solution and give kudos! 😀
It is closer,
It gives me sum of all selected weeks.
Maybe this? :
Skumulowany =
SUMX (
FILTER ( ALLSELECTED ( Tracker ), Tracker[RFS week] <= max(Tracker[RFS week]) ),
[Dane_suma]
)
_______________
If I helped, please accept the solution and give kudos! 😀
Thx guys, you help me a lot.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |