Counting the result of a measurement

[Syndicate_Admin]

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?

[Anonymous · Accepted solution]

Hi @Syndicate_Admin 

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.