cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper III

## FIXED SALES AMOUNT

hi team,
how to calculate fixed sales amount for finished goods  ,i have sale table and item group table
IF am apply any filter the fixed sales amount no need chnage

1 ACCEPTED SOLUTION
Community Support

Hi @rajasekar_o ,

Based on your description, I understand that you want the value of total to remain unchanged when the slicer is finished goods.

1.Create a measure

``````Measure =
CALCULATE (
SUM ( 'sale table'[sales amount] ),
FILTER (
ALL ( 'sale table' ),
'sale table'[group] = SELECTEDVALUE ( 'sale table'[group] )
)
)
``````

Output:

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Yifan Wang

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

Community Support

Hi @rajasekar_o ,

Based on your description, I understand that you want the value of total to remain unchanged when the slicer is finished goods.

1.Create a measure

``````Measure =
CALCULATE (
SUM ( 'sale table'[sales amount] ),
FILTER (
ALL ( 'sale table' ),
'sale table'[group] = SELECTEDVALUE ( 'sale table'[group] )
)
)
``````

Output:

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Yifan Wang

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