Qlik to PBI logic help

[Bharathi_99]

Hello guys,

Please help me in converting qlik logic to pbi

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

>
}

[E Number])


In PBI i Have  two tables, FACT and ACE
In fact table Type, category columns are ther and all other are in ace table
I have given relationship between these tables using key column

Please help
Thanks!

[v-shex-msft]

Hi @Bharathi_99 ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Bharathi_99]

I have many records like 770k , I cannot send some sample from there

[v-shex-msft]

HI @Bharathi_99,

Perhap you can try to use the following measure formula if this suitable for your scenario:

formula =
VAR currDate =
    MAX ( Calendar[Date] )
VAR quarterStart =
    DATE ( YEAR ( currDate ), QUARTER ( currDate ) * 3, 1 )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( Fact[E Number] ),
        FILTER (
            ALLSELECTED ( Fact ),
            AND ( [Imt Date] >= quarterStart, [Imt Date] <= currDate )
                && [Type] = "Northern"
                && [Category] = "INELIGIBLE"
                && [Parts Flag] = "Y"
        )
    )

Regards,

Xiaoxin Sheng