The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
11 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
22 | |
14 | |
14 | |
9 | |
7 |