How to Lock Value for measure

[kilala]

Hi all,

I have a measure that calculate value for brand after adjustment. Some business logic is applied, but in the end, i can get the amount after adjustment for all involved brands. for example:

Brand	Before	After
A	10000	15000
B	50000	55000
C	20000	21000

in my dashboard, i also put slicer that allows user to filter brands that they want to see. however, in my dashboard, looks like they also remove the brand from calclation, causing my current calculation is wrong. 

for example, if user filter Brand A &C, they should see following result:

Brand	Before	After
A	10000	15000
C	20000	21000

however, currently they are seeing other amount, example:

Brand	Before	After
A	10000	15000
C	20000	28000

how do i fix this? thanks.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your data model looks like, or how your measures look like, but please check the below picture and the attached pbix file.

I tried to create a sample pbix file.

I think, in your measure, if you tried to use ALLSELECTED function, then perhaps you can try to replace ALLSELECTED to ALL, like the sample pbix file that I attached.

[kilala]

Hi, 

Yes I think it's because I'm using ALLSELECTED instead of ALL in my measure. 

will correct all measures related. tqsm!

[amitchandak]

@kilala , You need to share the formula, I doubt it can change because of data refresh