Forum Discussion

Balhemkan's avatar
Balhemkan
Helper III
3 years ago

Freeze value

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

4 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

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

    AllAmount :=

    CALCULATE(

        SUM(TableName[SalesAmount]),

        ALL()

    )

     

    • Balhemkan's avatar
      Balhemkan
      Helper III
      3 years ago

      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's avatar
        FreemanZ
        Super User
        3 years ago

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