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,
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.
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 |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |