bi-powered cutters

[Syndicate_Admin]

can someone please try to help me with the next measure, specifically where I have highlighted the rose. I have two slicers that are NOT connected to my data source. the next measure if it works well, except for the fact that the POC filter only works when I have selected a value in the gender filter. For example, if I choose "Female" in my gender filter, I can select "Asian" in my POC filter and it will work properly, my POC filter only works if I have selected women or men. I want to be able to filter without woman or male selected, just a POC value. any idea why?

test 4

Filtered VAR ?

table with public filter conditions

FILTER (

'Talent Snapshot',

[Potential] <> ""

)

CTA_ADD VAR =

cta with additional filter

SUMX (

FILTER (

Filtered

IF (

ISFILTERED ( Gender[Gender] ),

[Gender] IN VALUES ( Gender[Gender] ),

TRUE ()

)

&& IF (

ISFILTERED ( PoC[PoC (USA Only)]),

[Race/Ethnicity] IN VALUES ( PoC[PoC (US ONLY)] ),

TRUE ()

)

),

[Total Partner Count (PME)]

)

CTA_RAW VAR =

cta with raw filter

SUMX ( Filtering, [Total Partner Count (PME)] )

_FLAGG VAR =

filter the genre of the flag

ISFILTERED ( Gender [Gender] )

VAR _round =

REDONDO (

IF (

_flagG,

MAX ( 0, DIVIDE ( cta_add, cta_raw ) ),

DIVIDE ( cta_raw, SUM ( [Count Total Associates (PME)] )

),

2

) * 100

_FIXED VAR =

MAX ( 0, VALUE ( FIXED ( IF ( _flagG, cta_add, cta_raw ), 0 ) )

Return

_round and "% (" and _fixed and ")"

[Anonymous]

Hi @Syndicate_Admin 

Due to I don't know your data model, I could only give you some advice.

Try to use or || not and && in IF function.

CTA_ADD VAR =
SUMX (
FILTER (
Filtered
IF (
ISFILTERED ( Gender[Gender] ),
[Gender] IN VALUES ( Gender[Gender] ),
TRUE ()
)
|| IF (
ISFILTERED ( PoC[PoC (USA Only)]),
[Race/Ethnicity] IN VALUES ( PoC[PoC (US ONLY)] ),
TRUE ()
)
),
[Total Partner Count (PME)]
)

Or you can try this measure:

CTA_ADD VAR =
VAR _SELECTGENDER = VALUES(Gender[Gender])
VAR _SELECTPOC =  VALUES ( PoC[PoC (US ONLY)] )
RETURN
SUMX (
FILTER (
ALL('TABLE'),
TABLE[Gender] IN _SELECTGENDER &&
TABLE[PoC (US ONLY)]IN _SELECTPOC
),
[Total Partner Count (PME)]
)

If this reply still couldn't help you solve your problem, you can share a sample with me by your Onedrive for Business.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.