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.
Good morning
I have a measure that calculates the days that orders have taken based on a filter, which distinguishes between one impediment or another, is as follows:
Clean Workdays = SWITCH([Stopper Seleccionado],
1, CALCULATE(SUMX(Developments, [WorkDays Start-End]-[CSA Stopper Time]+1)),
2, CALCULATE(SUMX(Developments, [WorkDays Start-End]-[Customer Stopper Time]+1)),
3, CALCULATE(SUMX(Developments, [WorkDays Start-End]-[Prod. Planning Stopper Time]+1)),
4, CALCULATE(SUMX(Developments, [WorkDays Start-End]-[Procurement Stopper Time]+1)),
5, CALCULATE(SUMX(Developments, [WorkDays Start-End]-[MRP Stopper Time]+1)),
6, CALCULATE(SUMX(Developments, [WorkDays Start-End]-[Total Stopper Time]+1)),
CALCULATE(SUMX(Developments, Developments[WorkDays Start-End]+1)))
I want to make a scatter plot, which on the X axis represents the number of days, and on the Y axis represents the number of orders that have taken to be made those days, depending also on the SWITCH filter. I therefore need a measure that takes stock of the first measure that I show here. How do I do it?
Solved! Go to Solution.
You can refer to the following solution
1.You can create a number table.
Days = GENERATESERIES(1,100,1)
2.Then create a new measure
Counts =
CALCULATE (
COUNTROWS ( Table ),
FILTER ( Table, [Clean Workdays] IN VALUES ( Days[Value] ) )
)
Then put the value of Days table to the x-axis, and put the measure to the y-axis.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can refer to the following solution
1.You can create a number table.
Days = GENERATESERIES(1,100,1)
2.Then create a new measure
Counts =
CALCULATE (
COUNTROWS ( Table ),
FILTER ( Table, [Clean Workdays] IN VALUES ( Days[Value] ) )
)
Then put the value of Days table to the x-axis, and put the measure to the y-axis.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
97 | |
97 | |
82 | |
74 | |
66 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |