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!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register 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])
User | Count |
---|---|
9 | |
8 | |
5 | |
4 | |
3 |