topic DAX Calculate by 2 category by date in DAX Commands and Tips

DAX Calculate by 2 category by date

Wicak — Fri, 25 Feb 2022 03:56:08 GMT

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

Re: DAX Calculate by 2 category by date

VahidDM — Fri, 25 Feb 2022 05:13:10 GMT

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/

Re: DAX Calculate by 2 category by date

Wicak — Fri, 25 Feb 2022 06:54:04 GMT

Thanks VahidDM 😁