FIXED SALES AMOUNT

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.

You can follow these steps to solve your problem:

1.Create a measure

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

Output:

 

 

How to Get Your Question Answered Quickly - Microsoft Fabric Community

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.}