Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello. I have faced with issue.
I have to write measure to show average.
Despite the slicer is activated (2023), measure shows documents from another period (2024), hovewer count properly (only 2023)
Thanks for any help.
Solved! Go to Solution.
I have found the answer. Thanks.
And this solution regarding to everything you need to disclose: month, year, document, category...
Average q-ty =
averagex(
values('Аркуш1'[Deliverynote]),
[measure average])
Hi, you need to put another filter in those measures like:
Table, date<selected value ( table date)
I have found the answer. Thanks.
And this solution regarding to everything you need to disclose: month, year, document, category...
Average q-ty =
averagex(
values('Аркуш1'[Deliverynote]),
[measure average])