Product sample control

Hi  Christianlekot ，

Here I will give you some suggestions on your code. According to your code, I think your code has a lot of duplicate parts that could be merged and simplified.

Krav prover =
ROUNDUP (
    CALCULATE (
        SUM ( 'Produktion'[Producerat antal] ) / 200,
        'Datum TI slutmarkering'[Månad, siffra]
            IN { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 },
        ALL ( 'Datum TI slutmarkering'[Månad, siffra] )
    ),
    0
)

Status prov =
/*Code for "done tests" - "demanded tests"*/
ROUNDUP (
    CALCULATE (
        DISTINCTCOUNT ( 'Kvalitetsdatarapporter'[Product order number] ),
        'Datum TI slutmarkering'[Månad, siffra]
            IN { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 },
        ALL ( 'Datum TI slutmarkering'[Månad, siffra] )
    ),
    0
)
    - ROUNDUP (
        CALCULATE (
            SUM ( 'Produktion'[Producerat antal] ) / 200,
            'Datum TI slutmarkering'[Månad, siffra]
                IN { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 },
            ALL ( 'Datum TI slutmarkering'[Månad, siffra] )
        ),
        0
    )

I think 'Datum TI slutmarkering'[Månad, siffra] should be the month column. As far as I know, there should be only 12 months in a year, so I am confused why you add the filter like  'Datum TI slutmarkering'[Månad, siffra] IN { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 } in your codes. 

Is there something others like blank in [Månad, siffra]?

If this reply still couldn't help you solve your issue, please share a sample file with us. And you can show us a screenshot with the result you want. This will make us easier to find the solution.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.