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 found the solution shared by lbendlin , to be appropriate and aligned with the original requirement. Could you please confirm if this resolved your issue?

If it worked as expected, we encourage you to mark the response as 'Accept as Solution' so that others with similar queries can benefit from it as well. If the issue still persists, feel free to share additional details so we can continue assisting you. Additionally, review  the PBIX file shared by Ashish_Mathur .

 

Please note, we were unable to download the file you attached from our end.

 

 

lbendlin  & Ashish_Mathur ,Thank you for your ongoing valuable contributions and involvement in the community.

 

Regards,

Yugandhar.