DAX Calculate by 2 category by date

[Wicak]

Table Product

table time

I have two table related to date. i want to sum per Product Category with Product category time. i want measure speed ( good product/time) per category, i have example 

then i try in PBI with new measure. i  have a problem when i create new measure, model like this 

Speed =

CALCULATE(

              SUM('Table Product'[SKU]'),

              ('Table Product'[SKU] IN { "SKU A" })

/ SUM('Time'[SKU A])

this model not error. but when i visualized, this measure error. this pop up   

please your advice, thanks 

[Wicak]

Thanks @VahidDM 😁

[VahidDM · Accepted solution]

Hi @Wicak 

Try this measure:

SPEED = 
VAR _A =
    SUM ( 'Time'[SKU A] )
VAR _B =
    SUM ( 'Time'[SKU B] )
VAR _C =
    SUM ( 'Time'[SKU C] )
VAR _SGP =
    SUM ( 'Table Product'[Good Product] )
VAR _SKU =
    MAX ( 'Table Product'[SKU] )
VAR _SWSK =
    SWITCH ( _SKU, "SKU A", _A, "SKU B", _B, "SKU C", _C )
RETURN
    _SGP / _SWSK

output:

Download the file: https://gofile.io/d/e2BlMk

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/