how to lock particular value in CARD visualization or in Multi row card

[Amardeep100115]

Need help on same query. i have data for last 7-8 months and want to lock same value which you locked in card visualization in shared power BI file. i wish to be have same output with month wise, could you please help me on this ? Thanks

please refer below link and attached screen snap

https://community.powerbi.com/t5/Desktop/how-to-lock-particular-value-in-CARD-visualization/m-p/5626...

[v-lili6-msft]

hi, @Amardeep100115 

You could use "ALLxxx" functions in DAX to create a measure to get it.

https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept...

https://docs.microsoft.com/en-us/dax/all-function-dax

You could add a conditional like ALL('Date' ) ,ALL('Date' [Month]) in the measure formula.

If you still have the problem, What is "month wise"?

please share a simple sample pbix file and expected output.https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Lin

[Amardeep100115]

 you can find the working file on below link

https://community.powerbi.com/t5/Desktop/how-to-lock-particular-value-in-CARD-visualization/m-p/5626...

OR find on below link

https://onedrive.live.com/?cid=0B49DB32F818EB2D&id=B49DB32F818EB2D%218265&parId=B49DB32F818EB2D%2182...

[v-lili6-msft]

hi, @Amardeep100115 

Please share your own sample data and expected output.

In that post, it could use "ALLxxx" functions in DAX to create a measure to get his requirement,

you could get it by the same logic, if you have the problem, Please share your own sample data and expected output.

Best Regards,

Lin

[Amardeep100115]

Please visit to below link to access required sample data

i wish to be have Base Amt should be lock in Multi Card visual month wise, 

https://onedrive.live.com/?cid=0B49DB32F818EB2D&id=B49DB32F818EB2D%218267&parId=B49DB32F818EB2D%2182...

[v-lili6-msft]

hi, @Amardeep100115 

We couldn't access to your sample pbix file.

Please upload again.

Best Regards,

Lin

[Amardeep100115]

Please try to access below link

https://1drv.ms/u/s!Ai3rGPgy20kLwEsQezJ-G1LO6jym

[v-lili6-msft]

hi, @Amardeep100115 

If you could use this formula to create a measure

Measure 2 = CALCULATE(SUM(data[Amount Base]),ALL(data[Month]))

Result:

Best Regards,

Lin

[Amardeep100115]

Could you please share me working file?

[v-lili6-msft]

hi, @Amardeep100115 

Here is pbix file, if you have any problem, please show the expected output by it.

Best Regards,

Lin

[Amardeep100115]

If you notice in below table i have clicked on 2019 bar in bar graph and in multi card visual filtered portfolio $/SF and locked value is global portfolio $/SF is deffernt  in below both snaps

i have used measure for global portfolio 

$ per SqFt G = CALCULATE(DIVIDE([ICE sum],[Total Site SqFt]),ALL('OL'))

and for filtered portfolio 

$ per SqFt = [ICE sum]/[Total Site SqFt]

Please advice

[v-lili6-msft]

hi, @Amardeep100115 

I check the data, for every Compaany ID, it has the same "Amount Base" for each Month.

So when you check any month, it won't change.

and for your own example, That's not what you're looking for?

what is your expected output?

Best Regards,

Lin

[Amardeep100115]

Sorry for confusion, 

If you see the below snap in that there two tiles for $38, 1) Filtered portfolio $/Sqft  and 2) Global portfolio $/Sqft

i wish to be have two different measure one of that display Filtered Base Amt $/Sqft  and another is Global base amout $/Sqft like Img 2.

revised data in file, please visit in below link:

https://1drv.ms/u/s!Ai3rGPgy20kLwEsQezJ-G1LO6jym?e=EtUNWD 

Img 2:

Img 1: 

[Amardeep100115]

Not Working on my P