topic Re: Freeze value in DAX Commands and Tips

Freeze value

Balhemkan — Tue, 06 Dec 2022 11:19:36 GMT

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 — Tue, 06 Dec 2022 11:50:50 GMT

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

AllAmount :=

CALCULATE(

SUM(TableName[SalesAmount]),

ALL()

)

Balhemkan — Tue, 06 Dec 2022 12:36:06 GMT

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 — Tue, 06 Dec 2022 14:05:17 GMT

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

Balhemkan — Tue, 06 Dec 2022 18:18:19 GMT