Forum Discussion
How to calculate the average difference between two measures doing a count on text values
Hi, I have two measures currently doing a count on a text field shown below Total Apples = COUNTROWS(FILTER('Table',[Category]="Apple")) Total Pears = COUNTROWS(FILTER('Table',[Category]="...
amitchandak
Super User
Super UserAnonymous , this is count, Avg based on what , Say Date, Month , Region, City etc.
Based on the need
Averagex(Values(Table[Month Year]), [Total Apples]) - Averagex(Values(Table[Month Year]), [Total Pears ])