Forum Discussion

JamesBurke's avatar
JamesBurke
Helper III
2 years ago
Solved

Dynamic

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. 

 

  • 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])

1 Reply

  • ajohnso2's avatar
    ajohnso2
    Solution Supplier

    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])