Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Lexporate
Regular Visitor

Measure displays wrong in the chart

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.

Screenshot_1.jpgScreenshot_2.jpgScreenshot_3.jpg
sample on google drive 

1 ACCEPTED 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])



image_2024-03-28_22-49-08.pngimage_2024-03-28_22-49-34.pngimage_2024-03-28_22-48-25.png

View solution in original post

2 REPLIES 2
Rupak_bi
Resolver II
Resolver II

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])



image_2024-03-28_22-49-08.pngimage_2024-03-28_22-49-34.pngimage_2024-03-28_22-48-25.png

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.