Forum Discussion

GeorgiBarov's avatar
GeorgiBarov
Frequent Visitor
8 years ago
Solved

Help! Filter doesn't work on measure

Hello, I'm trying to get the Average YTD per Context and Assay, but the formula that I'm using calculate the whole sum. For example in YTD (which is measure) I want to recieve Cu per context(Actual...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi GeorgiBarov,

    Based on the data model displayed, I make a test on my site and it turns out the result below. In calculated column (Sum per day) it can’t receive Cu per context.

     

    Can I confirm with you whether there is any other information when created the calculated column, additionally, to help you effectively, would you please give a picture showing a list of result you want in YTD column?

     

    Best regards,
    Maggie Li

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi GeorgiBarov,

Based on the data model displayed, I make a test on my site and it turns out the result below. In calculated column (Sum per day) it can’t receive Cu per context.

 

Can I confirm with you whether there is any other information when created the calculated column, additionally, to help you effectively, would you please give a picture showing a list of result you want in YTD column?

 

Best regards,
Maggie Li