Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago

bi-powered cutters

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.