Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Dimension =if(GetSelectedCount(Themes)>0,
if(match(Permalink,$(vCRP)) and not match(Themes,$(vCRT)),Themes),
if(match(Permalink,$(vCRP)) and not match(Themes,'$(vTh)'),Themes))
Solved! Go to Solution.
Hi @neelimakagolanu ,
You can try formula like below:
result =
IF (
COUNTROWS ( VALUES ( 'Themes'[Theme] ) ) > 0,
IF (
CONTAINSSTRING ( "vCRP", MAX(Themes[Theme]) ) && NOT CONTAINSSTRING ( "vCRT", MAX(Themes[Theme])),
MAX(Themes[Theme]),
BLANK ()
),
IF (
CONTAINSSTRING ( "vCRP", MAX(Themes[Theme]) ) && NOT CONTAINSSTRING ( "vTh", MAX(Themes[Theme])),
MAX(Themes[Theme]),
BLANK ()
)
)
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @neelimakagolanu ,
You can try formula like below:
result =
IF (
COUNTROWS ( VALUES ( 'Themes'[Theme] ) ) > 0,
IF (
CONTAINSSTRING ( "vCRP", MAX(Themes[Theme]) ) && NOT CONTAINSSTRING ( "vCRT", MAX(Themes[Theme])),
MAX(Themes[Theme]),
BLANK ()
),
IF (
CONTAINSSTRING ( "vCRP", MAX(Themes[Theme]) ) && NOT CONTAINSSTRING ( "vTh", MAX(Themes[Theme])),
MAX(Themes[Theme]),
BLANK ()
)
)
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @neelimakagolanu,
Can you try this:
MEASURE =
VAR __vCRP = "" //I don't know how this variable is populated in QlikSense
VAR __vCRT = "" //Same as above
VAR __vTH = "" //Same as above
VAR __Permalink = "" //Same as above
RETURN
IF (
HASONEVALUE ( Themes ),
IF (
OR (
AND (
CONTAINSSTRING ( __Permalink, __vCRP ),
NOT ( CONTAINSSTRING ( __Permalink, vCRT ) )
),
AND (
CONTAINSSTRING ( __Permalink, __vCRP ),
NOT ( CONTAINSSTRING ( __Permalink, vTH ) )
)
),
SELECTEDVALUE ( Themes ),
BLANK ()
),
BLANK ()
)