Forum Discussion

Jit007's avatar
Jit007
Helper II
1 year ago
Solved

Exclude data from overall calculations

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 

Need Help

6 Replies

    • Jit007's avatar
      Jit007
      Helper II
      1 year ago
      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's avatar
        Ashish_Mathur
        Super User
        1 year ago

        Hi,

        You mean something like this

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