how to lock particular value in CARD visualization

[Amardep1010]

I wish to be lock second value in CARD visualization($ 40.76 ) while filtering other data

[v-jiascu-msft]

Hi @Amardep1010,

That value looks like a measure. Since you only like to lock one value, the solution could be removing other contexts in the formula like below. If you'd like more details, please provide a sample.

Demo =
CALCULATE (
    SUM ( FactSales[SalesQuantity] ),
    ALL ( DimProduct ),
    ALL ( DimDate )
)
// add all the contexts you'd like to remove. the contexts means the filters in a sample way.

Best Regards,
Dale

[Amardep1010]

Data for work as requested Row 

Row Labels	Sum of Total Site SqFt	Total Base Rent	Occ-Base Rent	Base rent $/SqFt	Total ICE
ABCD- 1081	21975	$453,256	$20.63	57.53	$1,264,315.00
ABCD- 1237	2908	$33,442	$11.50	19.61	$57,023.00
ABCD- 4452	15368	$253,572	$16.50	60.45	$928,961.00
ABCD- 4499	96500	$1,529,257	$15.85	37.23	$3,592,426.00
ABCD- 6216	200957	$2,825,095	$14.06	10.67	$2,143,920.00
ABCD- 6218	200957	$2,014,514	$10.02	9.92	$1,992,659.00
ABCD- 6492	3466	$154,548	$44.59	65.16	$225,848.00
ABCD- 6793	6202	$243,453	$39.25	117.24	$727,124.00

[v-jiascu-msft · Accepted solution]

Hi @Amardep1010,

Please download the demo in the attachment. The measure could be like below.

Measure = CALCULATE(sum(Table1[Base rent $/SqFt]), all('Table1'))

Best Regards,
Dale

[Amardeep100115]

Hello friend, 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

[Amardep1010]

Hi  

Can you please guide me on below query

https://community.powerbi.com/t5/Desktop/how-to-filter-upcoming-project-by-project-date/m-p/540550#M...

[Amardep1010]

Hi  

Can you please guide me on below query

https://community.powerbi.com/t5/Desktop/how-to-filter-upcoming-project-by-project-date/m-p/540550#M...

[Amardep1010]

Thank you so much my friend