Translate Qlik Set Analysis into Power BI DAX

[Anonymous]

Hi Friends,

I am an advanced QV developer and looking for a PBI equivalent to QV's set analysis.

We have developed a complex report in Qlik. I'm trying to replacate the same in PBI.

Below is the logic for No.of Resolved Tickets as of now.

To get the same thing in PBI, I have created a new tabe (Related Table) with 1 column (Deriveddate).

Logic in Qlik: 

Count({<Deriveddate={'$(=Date(Max(CalendarMonthName),'MMM YYYY'))'},CalendarMonthName=>}
if(((IsNull(DateResolved) OR LEN(TRIM(DateResolved))<0) and DateClosed = Deriveddate)
or DateResolved = Deriveddate,TaskNumber))

Every thing is working fine except 

Count({<Deriveddate={'$(=Date(Max(CalendarMonthName),'MMM YYYY'))'},CalendarMonthName=>}
if(((IsNull(DateResolved) OR LEN(TRIM(DateResolved))<0) and DateClosed = Deriveddate)
or DateResolved = Deriveddate,TaskNumber))

In Qlik if you don't specify any value for a Dimension in filters, It will show all the values in the column.

Logic Built in PBI:

CALCULATE(COUNT(dim_Task[TaskNumber]),FILTER('dim_Task',(ISBLANK(dim_Task[DateResolved]) && dim_Task[DateClosed]=RELATED('Table'[Column])) || dim_Task[DateResolved]=RELATED('Table'[Column]))) 

Can any one please help how to build the same in PBI.

[v-jiascu-msft]

Hi @Anonymous,

Could you please provide a sample in TEXT mode? The .pbix file would be great. Though the Qlik formula is clear, can you make some explanations please?

Best Regards!

Dale

[Anonymous]

Hi,

Sorry for the delay in response.

Please find the below PBX file from the below link.

https://1drv.ms/u/s!AjhZlOtq-KU2alO9pHUCTX1ICZM