Forum Discussion

Krishna_Mysore's avatar
Krishna_Mysore
Icon for Helper II rankHelper II
2 years ago

Matrix Visual to display multiple measures but show only summary results for specific measures

I have a requirement to showcase a matrix visual to display three measures for sales order deliveries across different stores. Here are the details: Number of Sales Order Deliveries: This measure c...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    Hi,

    I revised your measure to

    Orders for delivery = CALCULATE(COUNT(Orders[Order No]),'Calendar'[Date]>=TODAY())

    I now see numbers in the combined visual

     

    • Krishna_Mysore's avatar
      Krishna_Mysore
      Icon for Helper II rankHelper II
      2 years ago

      Hi Ashish

       

      Thanks for your try. I only want to show the future dates for delivery with the Total column as well as  show "last delivery date" and "Days lapsed since last delivery" after the Total column in a single  matrix.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        2 years ago

        You are welcome.  Maybe some one can help you.