Qlik to Power Bi logic replication

[Bharathi09]

Hello All,

I have posted this question before, but haven't recieved correct response, I also tried but didn't exactly helped. I don't know this would be the right place to ask this question, but I am not so perfect in Qlik

I need below Qlik logic same in Power BI

count
(
DISTINCT
{
<
[Im Date]={">=$(=QuarterStart(max([Im Date]))) <=$(=date(max( [Im Date])))"},
FyQtr=,
Quarter=,
Year=,
[Type]={"Northern"},
[Category]={'INELIGIBLE'},
[En Number]=E({<[HM Flag]={'Y'},FyQtr=,Quarter=,Year=>}[En Number])

>
}

[En Number])

Could anyone please help....

Thanks!!!

[Anil_Babu_Samineni]

I suggest you to post the question in Power BI community. Better you explain about what the expression do in Qlik, so the respective community users will offer you.

[marcus_sommer · Accepted solution]

Both data-models must have a very similar star-scheme to be able to transfer an expression-logic. Beside this is querying / referencing the selection state and deriving on it the possible and/or the excluded values quite hard in Power BI which makes such simple Qlik logic very complex.

Like hinted you should investigate the logic + syntax within the Power BI community - by dividing the task to the most granular level and testing them separately (ignoring + overwriting selections, querying the selection + getting the excluded values).