Forum Discussion

rains_23's avatar
rains_23
Icon for Helper I rankHelper I
11 months ago
Solved

Totals in Matrix

Hi, I have created a matrix.  The below data gets filtered on a slicer for Date. So for each date, there may be multiple records of O, P, or S for each org name (column1). I want a total as 3, if i...
  • lbendlin's avatar
    lbendlin
    10 months ago

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
11 months ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

rains_23's avatar
rains_23
Icon for Helper I rankHelper I
10 months ago

It's the same data, except the condition was not added. I have amended the data in the same sheet now.

 

https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F135t1iSDz59lNGk1npZ629_IOkz7ZR1b6%2Fedit%3Fusp%3Ddrive_link%26ouid%3D105535431888411202482%26rtpof%3Dtrue%26sd%3Dtrue&data=05%7C02%7Crenu.agrawal-dongre%40comreg.ie%7Cf63f38333b294fe4cfc808de04b413c3%7C7e3063639dee4b8d8a6b4fee706b37fa%7C0%7C0%7C638953368677174665%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=CeZjmCSuxZG2QuVZTCUVMQnzHkstKoEpQd0T6YkM%2Fks%3D&reserved=0

 

lbendlin 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    10 months ago

     

    • rains_23's avatar
      rains_23
      Icon for Helper I rankHelper I
      10 months ago

      Thank you, it worked.

       

      I accepted it as a solution.

       

      Thanks a million.

       

      Rains