FIXED SALES AMOUNT

[rajasekar_o]

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 

[v-yifanw-msft · Accepted solution]

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