Freeze value

[Balhemkan]

Hi Team, 

I have two tables 

Dimension country column and business type column

Fact table country column, Sales amount and business type

I have given relationship from dim country column to fact country column. 

I'm using business type in slicer

My issue is if  I select anything in business type it should show total of sales amount. 

I have used "ALL" Dax function but when I select something in slicer data is filtering. I can't use edit interactions.

What ever we select in slicer it should show total .Data should not change.

I can't remove relationship because it will effect other columns.

Could you please suggest me. 

Thanks

[FreemanZ]

try not using the SalesAmount column but a measure with such code:

AllAmount :=

CALCULATE(

    SUM(TableName[SalesAmount]),

    ALL()

)

[Balhemkan]

@FreemanZ  - I tried this but not working. Actually my issue is. ... 

In Dim Business type we have values like A B C

In fact business type we have values like A  B C

When ever we select A  Or B it should show total of A B C. 

When ever we select C we should get only C total. 

Now when we select A it showing only A total instead of A B C. Please help me i stuck with these from two days

[FreemanZ]

could you please provide some sample data and ideally with the expected result?

[Balhemkan]

Hi @FreemanZ , 

Please find the below link for sample data and detailed requirement. https://drive.google.com/file/d/1IAc5Ux2R_0QbfBe_6EG2JlI_4nGtHRgv/view?usp=drivesdk