Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
82 | |
70 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |