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.

danextian's avatar
danextian
Super User
1 year ago

Hi swalke 

Please share a sample dataset in a usable format (not a screenshot), along with the expected output based on that data and your reasoning behind it. You may also upload an Excel file or a sanitized PBIX file via a cloud link. Preparing this may take some time, but so does arriving coming up with a solution.