I am doing migration report from Qlik to PowerBI.
I am wondering how to change this Qlik function into PowerBi.
=Num(Count(distinct {1 <[Type]-='Other',SaleDate=P(MasterCalenderDate)> } [CustomerId]) , '###,###,####')
Any help ?
1
I understood that you want to count distinct CustomerId where the type is different from ‘Other’ and where the SaleDate matches the MasterCalendarDate :
NumCustomers =
FORMAT(
COUNTROWS(
FILTER(
ALL(CustomerTable),
CustomerTable[Type] <> "Other" &&
CustomerTable[SaleDate] IN VALUES(MasterCalendar[MasterCalendarDate])
)
),
"###,###,####"
)