Forum Discussion

swalke's avatar
swalke
Frequent Visitor
1 year ago
Solved

Filter

Hello, Need to create a measure to show sales with below conditions. 1) A matrix visual to show sales by quarter and category (2 category) so all previous quarters sales (ignoring the date slicer)...
General Comment
Need Help
Tips and Tricks
  • v-hjannapu's avatar
    v-hjannapu
    1 year ago

    Hi swalke,

    Thank you  for reaching out to the Microsoft fabric community forum.

    As per your requirement, the final solution shows sales for all previous quarters regardless of the slicer, and only current quarter sales filtered by selected dates using a disconnected quarter table and a smart DAX measure. The matrix now accurately displays quarters in rows and categories in columns with correct values.

    I tested it with my sample data, and it worked fine. Please find the attached screenshot and Pbix for your reference.

     

    Hope this helps if you have any queries we are  happy to assist you further.
    Best Regards,
    Harshitha.

v-hjannapu's avatar
v-hjannapu
Community Support
1 year ago

Hello swalke,
Thank you for posting your query in Microsoft Fabric Community Forum. Also, thanks to rohit1991, danextian,   burakkaragoz  for those inputs on this thread. 

I wanted to check if you had the opportunity to review the information provided earlier Please feel free to contact us if you have any further questions.


Regards,
Harshitha.

  • v-hjannapu's avatar
    v-hjannapu
    Community Support
    1 year ago

    Hi swalke,
    I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.

    Regards,
    Harshitha.