How to use filter to calculate average for specific category
@ dax users Hi Team, Attached are screen shots for the data model i am currently worknig on . So the issues was i wanted 2 lines and one column in Coombo chart , hence i had to create measure to show them individually If you have similar problem try to use below : Full Abatement Target = CALCULATE(AVERAGE('Compliance Abatable 12 Month'[Score]),FILTER('Compliance Abatable 12 Month','Compliance Abatable 12 Month'[Details]="Full Abatement Target")) Hope this example helps you
