Forum Discussion

Lexporate's avatar
Lexporate
Frequent Visitor
2 years ago
Solved

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.


sample on google drive 

  • Lexporate's avatar
    Lexporate
    2 years ago

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



2 Replies

  • Rupak_bi's avatar
    Rupak_bi
    Icon for Super User rankSuper User
    2 years ago

    Hi, you need to put another filter in those measures like:

    Table, date<selected value ( table date)

     

    • Lexporate's avatar
      Lexporate
      Frequent Visitor
      2 years ago

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