topic Qlik to power bi dax it is very urgent in DAX Commands and Tips

Qlik to power bi dax it is very urgent

Anonymous — Fri, 01 Mar 2024 13:03:58 GMT

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

Re: Qlik to power bi dax it is very urgent

govindarajan_d — Fri, 01 Mar 2024 13:35:36 GMT

Hi Anonymous,

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

Re: Qlik to power bi dax it is very urgent

Anonymous — Mon, 04 Mar 2024 07:47:57 GMT

Hi Anonymous ,

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.