How to use filter to calculate average for specifi...

All forum topics
Previous Topic
Next Topic

@ 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