Forum Discussion

jimbob2285's avatar
jimbob2285
Icon for Advocate IV rankAdvocate IV
1 year ago
Solved

measure without context in summarised table

Hi   I've created a measure to show sales as at a certain date (month) , which is selected by the user via a slicer, hence the need for a measure rather then a column, as columns aren't reactive to...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    Something like this?

    V = CALCULATE(sum(Sales[Value]),TREATAS(VALUES('Calendar'[Date]),Sales[Date]))
V-yubandi-msft's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi jimbob2285 ,

We noticed we haven't received a response from you yet, so we wanted to follow up and ensure the solution we provided addressed your issue. If you require any further assistance or have additional questions, please let us know.

Your feedback is valuable to us, and we look forward to hearing from you soon.