Forum Discussion

24601's avatar
24601
Frequent Visitor
2 years ago

Long Term Measure Suddenly Not Working

Hi, My organization has been using a measure for years without any problem and in the last 4 days there have been issues.  The measure is a simple count rows of a sales fact table, filtered by ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  24601 ,

 

In your description it is mentioned that: when adding another Sales Volume Value Calculation item for a specific product filter, the metric gives incorrect values. It is possible that this screening context is causing the error.

Measure_ =
CALCULATE (
    COUNTROWS ( Sales ),
    USERELATIONSHIP ( 'Calendar'[Date], Sales[Date Sold] ),
    FILTER (
        ALLEXCEPT ( Sales, Sales[project] ),
        [Date Sold] >= DATE ( 2018, 1, 1 )
    )
)

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.