Multiple filter conditions in calculate from two different tables

[v_mark]

Hi, 

I need to know how many IDs are affected by this kind of filter. 

There are two tables involved in this process 

Which connected through Many To One relationship 

Initially, I create a measure 

Count Incidents = count(IncidentIDs) 

FinalMeasure=

CALCULATE (

[Count Incidents],

'Incident[IncidentType] = "Incident",

'Incident'[AssignedTeam] = "Helpdesk",

'Incident'[Status] = "Closed",

'Incident'[LinkedProblem] = BLANK (),

'Task'[ParentPublicID] = "Incident",

'Task'[OwnedByTeam] = "Helpdesk",

'Task'[Status] = "Closed",

'Task'[CloseCode] = "Completed"

)

Not sure if this is the right way to write this kind of calculate but ideally I want to know the proper way to write it.

Any Suggestion or Tips is highly appreciated 

Thank you in advance

[Anonymous]

Read or watch these:

Power BI – Star schema or single table - SQLBI

Understand star schema and the importance for Power BI - Power BI | Microsoft Docs

Currently your model is very sub-optimal.

[v_mark]

Will the final measure will not work on this kind of model? 

[Anonymous]

@v_mark 

Your measure may work on the model you have. I'm trying to shield you from problems later down the line... But it's up to you if you choose to ignore or follow.

By the way, you have showed a measure but you have not told us what you really want your measure to do. So, you've got a measure that does something but nobody knows if this is what you want the measure to do... You might say: "Wait! But I've told you at the very beginning of my post!" Well, not really. Your measure does not obey filters that might already exist on the columns you've put in your measure. Is this what you want? Nobody knows... If you want the filters coming from outside to be honored, you have to wrap the relevant filters in your measure in KEEPFILTERS. For instance. But I'd suggest you should really start with reading the articles I've given you links to.

[v_mark]

yes I want to honor those outside filters