Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi!
I would need some help with the following situation which I have trouble solving.
I'd like to create an average per category in a measure that ignores slicer selection for the same category.
I tried by using ALL function, but it has an effect on the VALUES part of the measure as well.
Total Session by Campaign =
CALCULATE(
AVERAGEX(
KEEPFILTERS(VALUES('Analytics'[Campaign])),
CALCULATE([Total Sessions])
), ALL('Analytics'[Campaign])
)
I possible, I would need to solve this inside the measure since I can't disable visual interactions in this use-case.
Thanks in advance and reach out if any more detail is needed.
Barna
Solved! Go to Solution.
Hi @Barnee ,
Please update the formula of your measure "Total Sessions average per Campaign for all the campaigns" as below:
Total Sessions average per Campaign for all the campaigns = AVERAGEX(ALL(sampledata[Campaign]),[Total Sessions])
I updated it in your sample file, you can get the file from this link.
Best Regards
Rena
@Barnee , you are using keep filter and all on same field
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi @Barnee ,
Please update the formula of your measure "Total Sessions average per Campaign for all the campaigns" as below:
Total Sessions average per Campaign for all the campaigns = AVERAGEX(ALL(sampledata[Campaign]),[Total Sessions])
I updated it in your sample file, you can get the file from this link.
Best Regards
Rena
User | Count |
---|---|
98 | |
89 | |
82 | |
70 | |
67 |
User | Count |
---|---|
114 | |
104 | |
101 | |
72 | |
65 |