ISFILTERED returning true value

[mmills2018]

Hello, I am using ISFILTERED in a calculation but it keeps returning true and not the actual values, any ideas why? below is my measure i am using

IF(ISFILTERED('Mgmt Levels'[Management Levels]),

ISINSCOPE( Goals[Group]),SELECTEDVALUE(Goals[2021 Female Goal]))||if(ISINSCOPE(Goals[Platform]),CALCULATE(sum(Goals[2021 Female Goal]),Goals[IsPlatform]=1))

[AlexisOlson]

How do you expect Management Levels to affect the calculation?

[mmills2018]

So, the below calcuation is actually working for me .  I have it set to filter on a specific value in my management level filter (M1-M3).  the issue with this measure is, i don't want to only filter on M1-M3, I want to filter on other values, any ideas?

var filtered = FILTER ('Goals',Goals[Mgmt Levels]= "M1-M3")

VAR _goal = SUMX(FILTER (filtered,[Mgmt Levels] in VALUES (Goals[Mgmt Levels])),IF(

ISINSCOPE( Goals[Group]),(Goals[2021 Female Goal]),if(ISINSCOPE(Goals[Platform]),CALCULATE(sum(Goals[2021 Female Goal]),Goals[IsPlatform]=1))))

return

_goal

[AlexisOlson]

Does this work?

SUMX (
    'Goals',
    IF (
        ISINSCOPE ( Goals[Group] ),
         ( Goals[2021 Female Goal] ),
        IF (
            ISINSCOPE ( Goals[Platform] ),
            CALCULATE ( SUM ( Goals[2021 Female Goal] ), Goals[IsPlatform] = 1 )
        )
    )
)

Assuming this is a measure, the Goals table will be filtered by whatever you set your Mgmt Levels to be.

[mmills2018]

unfortunately, it doesnt work.  I want my snapshot table to filter and not my goals table.  I still need to somehow connect the management level from my goals able to the management level from my snapshot data?

[AlexisOlson]

Sorry. I'm just shooting in the dark here since I still can't quite tell what's going on and what you're trying to do.

What if you replace the 'Goals' table argument from my suggestion with the following?

FILTER ( 'Goals', Goals[Mgmt Levels] IN VALUES ( 'Mgmt Levels'[Management Levels] ) )

If that doesn't work, I'd suggest trying to rewrite your question so that other people can understand it better.

[mmills2018 · Accepted solution]

OMG, that worked! THANK YOU!  One more question, if nothing in the filter is selected is there a way to set it to default to a certain number?

[v-shex-msft]

Hi @mmills2018,

Perhaps you can try to use 'if statement' to package and switch between two different conditions:

FILTER (
    'Goals',
    IF (
        COUNTROWS ( VALUES ( 'Mgmt Levels'[Management Levels] ) ) > 0,
        Goals[Mgmt Levels] IN VALUES ( 'Mgmt Levels'[Management Levels] ),
        Goals[Mgmt Levels] = "default value"
    )
)

Regards,
Xiaoxin Sheng

[BA_Pete]

Hi @mmills2018 ,

If your first IF condition resolves to TRUE i.e. 'Mgmt Levels'[Management Levels] is filtered, then your output will be ISINSCOPE(...).

ISINSCOPE gives a boolean output, which is where I would guess your boolean measure result is coming from.

IF(
  ISFILTERED('Mgmt Levels'[Management Levels]),
  ISINSCOPE( Goals[Group]),     //This function gives Boolean output when first condition is TRUE
  SELECTEDVALUE(Goals[2021 Female Goal])
)
||
IF(
  ISINSCOPE(Goals[Platform]),
  CALCULATE(
    SUM(Goals[2021 Female Goal]),
    Goals[IsPlatform]=1
  )
)

Pete

[mmills2018]

So, the below calcuation is actually working for me .  I have it set to filter on a specific value in my management level filter (M1-M3).  the issue with this measure is, i don't want to only filter on M1-M3, I want to filter on other values, any ideas?

var filtered = FILTER ('Goals',Goals[Mgmt Levels]= "M1-M3")

VAR _goal = SUMX(FILTER (filtered,[Mgmt Levels] in VALUES (Goals[Mgmt Levels])),IF(

ISINSCOPE( Goals[Group]),(Goals[2021 Female Goal]),if(ISINSCOPE(Goals[Platform]),CALCULATE(sum(Goals[2021 Female Goal]),Goals[IsPlatform]=1))))

return

_goal

[mmills2018]

so, i am trying to not get a boolean output, when i use the measure below, i get the values that i want:

IF(

ISINSCOPE( Goals[Group]),SELECTEDVALUE(Goals[2021 Female Goal]),if(ISINSCOPE(Goals[Platform]),CALCULATE(sum(Goals[2021 Female Goal]),Goals[IsPlatform]=1)))

I am trying to add a slicer to this measure from an unrelated table. any ideas how i can do this without getting a boolean output?

[BA_Pete]

@mmills2018 ,

I'm not entirely sure what you mean by "add a slicer...from an unrelated table".

It's very difficult for me to know what you need without seeing your data/data model and without knowing what this measure is supposed to do or what your desired output looks like.

Pete

[BA_Pete]

@mmills2018 ,

I think I understand what you're getting at here now.

Have you tried just amending your first condition to include the requirement for your [Mgmt Levels] field to be filtered? Something like this:

IF(
  ISINSCOPE( Goals[Group]) && ISFILTERED('Mgmt Levels'[Management Levels]),
  SELECTEDVALUE(Goals[2021 Female Goal]),
  IF(
    ISINSCOPE(Goals[Platform]),
    CALCULATE(
      sum(Goals[2021 Female Goal]),
      Goals[IsPlatform]=1
    )
  )
)

Pete