Forum Discussion

jdevalk77's avatar
jdevalk77
Frequent Visitor
3 years ago
Solved

Multiply per service

Hi, as a beginner in DAX I need some help for something which looks quite simple (and probably it is), but I don't know the solution. I do have a table with standard time in minutes per service an...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi jdevalk77 ,

    Please try below steps:

    1. create measure with below dax formula

    Measure =
VAR cur_service =
    SELECTEDVALUE ( Table1[Service] )
VAR cur_mt =
    CALCULATE ( MAX ( Table1[Minutes] ), Table1[Service] = cur_service )
VAR tmp =
    FILTER ( ALL ( Table2 ), Table2[Service] = cur_service )
VAR _val =
    SUMX ( tmp, [Quantity] )
RETURN
    cur_mt * _val

    Measure 2 = SUMX(VALUES(Table1[Service]),[Measure])

    2. add a table visual with field and measure

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi jdevalk77 ,

Please try below steps:

1. create measure with below dax formula

Measure =
VAR cur_service =
    SELECTEDVALUE ( Table1[Service] )
VAR cur_mt =
    CALCULATE ( MAX ( Table1[Minutes] ), Table1[Service] = cur_service )
VAR tmp =
    FILTER ( ALL ( Table2 ), Table2[Service] = cur_service )
VAR _val =
    SUMX ( tmp, [Quantity] )
RETURN
    cur_mt * _val

Measure 2 = SUMX(VALUES(Table1[Service]),[Measure])

2. add a table visual with field and measure

Please refer the attached .pbix file.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly