Forum Discussion
Converting Report Services Queries to Power BI
I have a report that I am trying to convert to PowerBI. I would like to have cards that display the following information: Service Requests Awaiting Triage: select count(*) AS 'SR Needing Tri...
I have cards for Open Service Requests and Open Help Desk done. That was easy. However it's this part in the other cards:
where iri_customertype='Internal' and status NOT IN ('Closed', 'Resolved')
and isnull((Select count(*) from Task where task.ParentLink_RecID=Incident.RecId and (Task.Status in ('Cancelled','Completed','Rejected','Reassigned'))),0) =0
It can be achieved by DAX formula, basically you need to apply filter expression in DAX. If you can send a sample data in excel sheet, will able to create something, in the meantime, here is the link for you to take a look.
You need to use calculate function with filter expression
https://msdn.microsoft.com/en-us/library/ee634825.aspx?f=255&MSPPError=-2147217396