Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

measure that shows YOY difference that excludes future dates

I'm trying to write a measure that filters out future values when compairing YOY difference, and I was able to do this.  However, when I use that measure against customer, my total is correct by at t...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous,

    In fact, measure expressions are calculated based on their row contents. You can't direct calculated through different measure expressions that calculate based on their own category groups.

    For this scenario, you can try to create a variable with summarize function to manually restore their category group and correspond row content for keeping raw calculation results. Then you can do aggerate and calculate between these variables.

    All the secrets of SUMMARIZE - SQLBI
    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous,

In fact, measure expressions are calculated based on their row contents. You can't direct calculated through different measure expressions that calculate based on their own category groups.

For this scenario, you can try to create a variable with summarize function to manually restore their category group and correspond row content for keeping raw calculation results. Then you can do aggerate and calculate between these variables.

All the secrets of SUMMARIZE - SQLBI
Regards,
Xiaoxin Sheng