Forum Discussion

gav1991's avatar
gav1991
Frequent Visitor
2 years ago
Solved

Dynamic total measure , based on slicer

Hi, I'm trying to calculate dynamic total, for the total orders palced YTD (i already have a seperate column for the total by week), also there is multiple customers in slicer. When i select the slic...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi gav1991 ,

     

    Please try below code to create a [Acutal %] measure.

    Actual % =
CALCULATE (
    DIVIDE (
        SUM ( 'Order'[Orders placed ≤ 1 Day] ),
        SUM ( 'Order'[Total No of Orders placed] )
    ),
    ALLEXCEPT ( 'Order', 'Order'[Customer] )
)

    Result is as below.

     

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi gav1991 ,

 

Please try below code to create a [Acutal %] measure.

Actual % =
CALCULATE (
    DIVIDE (
        SUM ( 'Order'[Orders placed ≤ 1 Day] ),
        SUM ( 'Order'[Total No of Orders placed] )
    ),
    ALLEXCEPT ( 'Order', 'Order'[Customer] )
)

Result is as below.

 

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.

gav1991's avatar
gav1991
Frequent Visitor
2 years ago

thanks Anonymous it worked much appriciated.