Forum Discussion
Jit007
Helper II
Helper IIExclude 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...
Hi,
PBI file attached.
Hope this helps.
Jit007Helper II
Helper IIMeasure = 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
Super User
Super UserHi,
You mean something like this
Measure = if(HASONEVALUE('Table 1'[TK #]),[Avg],CALCULATE([Avg],'Table 1'[FG]="ABC"||'Table 1'[FG]="XYZ"))- Jit007
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.