Forum Discussion

Balhemkan's avatar
Balhemkan
Icon for Helper III rankHelper 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 fa...
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper 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
Icon for Helper III rankHelper 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