Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi ,
i have my data here:
How can i get average sale not affected my slicer "type" ?
I want to calculate the average for status "Active" for different region and country in different month. I don't want the Type slicer is applied to my average in this graph .
My file is here : https://1drv.ms/u/s!ApIDnMK2eKiFgQJr9w9NZ7Hr8fQS?e=fYjt0f
thanks
Solved! Go to Solution.
try
Average Sale =
var numerator = CALCULATE(SUM(Sheet4[Sale ]),Sheet4[Status]="Active",ALL(Sheet4[Type]))
var denominator = CALCULATE(COUNTROWS(Sheet4),Sheet4[Status]="Active",ALL(Sheet4[Type]))
return
divide(numerator,denominator)
try to use option Edit interaction for your type s;licer - https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
deactivate Average sales chart for this slicer
is there a way to do with changing measure ?
There is still other thing in the same chart that i want the "Type" slicer to be applied .
I want to count number of countries in the month that the sale below the average ?
Number of countries will be applied filter "Type", but average is not .
and i want these 2 measure are in the same gragh
@ktt777
Go with this measure:
Average Sale = var numerator = CALCULATE(SUM(Sheet4[Sale ]),FILTER(ALL(Sheet4),Sheet4[Status]="Active"),
FILTER(ALL(Sheet4),[Period].[Month]=MAX([Period].[Month])))
var denominator = CALCULATE(COUNTROWS(Sheet4),FILTER(ALL(Sheet4),Sheet4[Status]="Active"),
FILTER(ALL(Sheet4),[Period].[Month]=MAX([Period].[Month])))
return divide (numerator, denominator)
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
try
Average Sale =
var numerator = CALCULATE(SUM(Sheet4[Sale ]),Sheet4[Status]="Active",ALL(Sheet4[Type]))
var denominator = CALCULATE(COUNTROWS(Sheet4),Sheet4[Status]="Active",ALL(Sheet4[Type]))
return
divide(numerator,denominator)
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |