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.
Dear ALL,
I am completly new to power BI, so please be patent with me.
I now that this topick was opened before and i had tried to use suggestions from previous posts, but with no success.
Here is my example:
I want to represent "line and stacked column chart" where columns would represent number of lines per LDM (loading meters) class and line should be cumulative value of LDM's from shipment class 1 to 10.
Meaning:
Class1 = sum of LDM in that class
Class2 = LDM from class 1 + LDM from class 2
etc..
this is data set:
and this is formula i am using:
accumulative LDM Column = CALCULATE(sum('Try me'[Shipment Loading Meters (LM)]); filter(ALL('Try me'[Ship Class]); 'Try me'[Ship Class]<=max('Try me'[Ship Class])))
But, as you can see, i am doing something wrong here, since it is always displaying this chart:
Any suggestions? Please explain me, what am i doing wrong here, since i dont understand these expressions at all.
Many thanks.
Solved! Go to Solution.
In you case, you may need a measure as below. See more in the attached pbix file.
accumulative LDM = SUMX ( FILTER ( ALLSELECTED ( yourTable ), yourTable[ship class] <= MAX ( yourTable[ship class] ) ), yourTable[Shipment Loading Meters] )
In you case, you may need a measure as below. See more in the attached pbix file.
accumulative LDM = SUMX ( FILTER ( ALLSELECTED ( yourTable ), yourTable[ship class] <= MAX ( yourTable[ship class] ) ), yourTable[Shipment Loading Meters] )
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 |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |