Exclude data from overall calculations

[Jit007]

Need help on this scenerio :  PBIX file 

I have two tables as below 

1 table- Raw data Score from database

2 table- Analyzed data only for score=1 

For New avarage - I'm trying to show here after analyzing the 1 score TK data where the fault grp is not same grp name as per raw data then exclude those tickets from overall aveg calculations & include only TK data 1 score where fault grp & grp name is same in both tables & other TK as it is as per shown below 

how to get this in power bi..Thanks

@Ashish_Mathur 

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[Jit007]

Measure = if(HASONEVALUE('Table 1'[TK #]),[Avg],CALCULATE([Avg],'Table 1'[FG]<>"Other grp"))

What if i have other group name in coloumn instead of  only"Other grp". i.e.- New Group, Diff group, inactive group 

Is there anyway i can refer only if = ABC or XYZ then calculate the avg & if not ignore..Thanks

@Ashish_Mathur 

[Ashish_Mathur]

Hi,

You mean something like this

Measure = if(HASONEVALUE('Table 1'[TK #]),[Avg],CALCULATE([Avg],'Table 1'[FG]="ABC"||'Table 1'[FG]="XYZ"))

[Ashish_Mathur]

Hi,

You mean something like this

Measure = if(HASONEVALUE('Table 1'[TK #]),[Avg],CALCULATE([Avg],'Table 1'[FG]="ABC"||'Table 1'[FG]="XYZ"))

[Jit007]

File 

I'm struggling to get this solution as added NEW Score column - if in analyzed 2nd table the fault group is not same as raw table- attached same PBIX file 

[Ashish_Mathur]

Hi,

Not sure of what you want.  Explain the question and show the expected result.