Dynamic

[JamesBurke]

HI all , 

Test = 
 var sourcetable = FILTER(SUMMARIZECOLUMNS('Date'[Date],'Emporia Devices'[Wawrick Device Name (groups)],"RankMeasure",[Rank DeviceName Usage]),'Emporia Devices'[Wawrick Device Name (groups)] = "Thornton Building")
RETURN
COUNTX(FILTER(sourcetable,[RankMeasure] = 3),[RankMeasure])

This works but i would like to make it dynamic so whenever a building is selected it does this same result 

Test 2 = 
 var sourcetable = FILTER(SUMMARIZECOLUMNS('Date'[Date],'Emporia Devices'[Wawrick Device Name (groups)],"RankMeasure",[Rank DeviceName Usage]),SELECTEDVALUE('Emporia Devices'[Wawrick Device Name (groups)] ))
RETURN
COUNTX(FILTER(sourcetable,[RankMeasure] = 1),[RankMeasure])

This says can't convert type of text to true/False 

Thanks , James. 

[ajohnso2 · Accepted solution]

You missed some code.

Test 2 = 
 var sourcetable = FILTER(SUMMARIZECOLUMNS('Date'[Date],'Emporia Devices'[Wawrick Device Name (groups)],"RankMeasure",[Rank DeviceName Usage]), 'Emporia Devices'[Wawrick Device Name (groups)] = SELECTEDVALUE('Emporia Devices'[Wawrick Device Name (groups)] ))
RETURN
COUNTX(FILTER(sourcetable,[RankMeasure] = 1),[RankMeasure])