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.
I need to upgrade my current measure to include a variable
Hi @RonaldvdH
maybe this will help:
Cumulatieve HC geforecast =
CALCULATE ([Totaal geforecast aantal HC];
FILTER(
ALL('Forecast FttH');
'Forecast FttH'[Week]<=MAX('Forecast FttH'[Week]) && 'Forecast FttH'[Project] = SELECTEDVALUE('Forecast FttH'[Project])
))
do not hesitate to give a kudo to useful posts and mark solutions as solution
@az38 thanks for your quick response and it looks like it works but i need to examine your solution further.
What i can see is that is works fine when i select just 1 project but when i select both the measure doesn't seem to work
or in the very least the result is very strange
Any ideas ?
if you select both project what your desired result? project A + projcet B or it still should be divided?
do not hesitate to give a kudo to useful posts and mark solutions as solution
Then it should be combined to 1 result
Selection Value
Project A 200
Project B 300
Project C 200
Project D 100
Project A+B 500
Project A+B+C 700
Select All 800
so, let us know if my measure will not work
do not hesitate to give a kudo to useful posts and mark solutions as solution
I just did 🙂 because the result isn't correct when you select more then 1 project
Hi @RonaldvdH ,
When you select multiple projects in slicer, what results should be shown while the project is in the same week? It should be calculated cumulative values together or separately based on the projects? It should show the total values in the total row like below? If so, you just need to create a new measure by SUMX function and use the formula that @az38 suggested. Or it should show the total values in each row?
Measure 1 = SUMX('Forecast FttH',[Measure])
Please show your expected results. Then we will understand clearly.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-xuding-msft and @az38
ive altered the measure to:
whats your desired output based on your data example?
whats output you expect for slicer A and for slicer A+B? How it should look like?
do not hesitate to give a kudo to useful posts and mark solutions as solution
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |