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"))