Trying to return a unichar with hasonevalue() and using a measure

[Anonymous]

Trying to return a unichar with hasonevalue() and using a measure

ButtonHasFilter = if(hasonefilter('Staffing Report'[Location]),unichar(9744),unichar(9745))

but this is not working properly, I am getting all 9744 only even when there is no selection.

Is there a way I can use a measure inside hasonefilter()

I am using this measure for a table visual

Thanks

@Anonymous @Greg_Deckler @amitchandak @MFelix

[v-yingjl · Accepted solution]

Hi @Anonymous ,

You can create a measure like this:

A =
VAR _count =
    CALCULATE (
        COUNT ( 'Staffing Report'[Location] ),
        ALLSELECTED ( 'Staffing Report' )
    )
VAR allcount =
    CALCULATE ( COUNT ( 'Staffing Report'[Location] ), ALL ( 'Staffing Report' ) )
RETURN
    IF ( _count >= 1 && _count < allcount, UNICHAR ( 9745 ), UNICHAR ( 9744 ) )

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@Anonymous - Are you using HASONEFILTER or HASONEVALUE? What is the formula for the measure? Is the measure Location?

[Anonymous]

@Greg_Deckler 

this is my measure,

Location_Sli =

VAR _overallloc =

CALCULATE (

ROUND ( [Overall % Mgmt] * 100, 0 ),

ALLEXCEPT ( 'Staffing Report', 'Staffing Report'[Location] )

)

VAR _redgreen =

IF ( _overallloc >= 90, "🟢", "🔴" )

VAR _location_sli =

IF (

MIN ( 'Staffing Report'[Location] ) = BLANK (),

BLANK (),

CONCATENATE (

CONCATENATE (

CONCATENATE ( _redgreen, MIN ( 'Staffing Report'[Location] ) ),

"-"

),

_overallloc & "%"

)

)

RETURN

_location_sli

I want to use this inside the ButtonHasFilter and return a unichar when there is a selection which is a checked box, otherwise an unchecked box.

Thanks for your help in advance @Greg_Deckler 

[Greg_Deckler]

@Anonymous Well, I guess the simple answer is, you cannot use a measure in HASONEFILTER. According to the documentation, you have to use a column:

HASONEFILTER function (DAX) - DAX | Microsoft Docs

[Anonymous]

Yes, I am aware but any work-around would be helpful here @Greg_Deckler