Forum Discussion

XuanHau's avatar
XuanHau
Icon for Helper I rankHelper I
2 years ago

Calculate data at max startdate based on slicers

  Hi, I need help with my report. I have: A table named A (fact) with 3 columns: group, Start date, quantity. A Datetable and a Grouplist table. Relationships: Startdate-datetable, group-groupl...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
XuanHau's avatar
XuanHau
Icon for Helper I rankHelper I
2 years ago

Hi Anonymous 

The workaround measure works for me, but I have a question: can we include it in a measure instead of using a filter? I also use quantity at the max date in another measure.

I have attached the link to my report in the original post for my example data (this file does not use the workaround you mentioned).

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi XuanHau ,

 

I'm afraid can't. The measure just returns a number, it can't be used as Filter in column field. In general, we recommend that user put the measure in Filter and complete the row filter based on the value returned by the measure.😀

 

Best regards,

Mengmeng Li