Forum Discussion

maamirkhan2023's avatar
maamirkhan2023
Icon for Helper I rankHelper I
1 year ago
Solved

Incorrect Column Totals in Matrix showing

Hi All  Incorrect Column Totals in Matrix showing  Here is the dax I have used still showing Incorrect Column Totals in Matrix showing  VAR __table = SUMMARIZE(Q_Host_List_Detection_HOSTS,"__val...
data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-dineshya's avatar
    v-dineshya
    1 year ago

    Hi maamirkhan2023 ,

    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. If possible please provide sample PBIX file.


    Regards,
    Dinesh

v-dineshya's avatar
v-dineshya
Icon for Community Support rankCommunity Support
1 year ago

Hi maamirkhan2023 ,

Thank you for reaching out to the Microsoft Community Forum.

Please follow below steps.

 

1. Created sample data based on your screenshot. please refer below.

 

 

2. In Power Query editor, I have done trasformation on month columns (Unpivot columns from Jan to july). Please refer below snap.

 

 

3. Created measure "Detection Count" with below DAX code.

 

Detection Count =
VAR SummaryTable =
    SUMMARIZE(
        'Host_Detections',              
        'Host_Detections'[Asset Tags],
        "Cnt", SUM('Host_Detections'[DetectionCount])
    )
RETURN
IF(
    HASONEVALUE('Host_Detections'[Asset Tags]),
    SUM('Host_Detections'[DetectionCount]),
    SUMX(SummaryTable, [Cnt])
)
 
4. Please refer output snap and attached PBIX file.
 

 

I hope this information helps. Please do let us know if you have any further queries.

 

Regards,

Dinesh

  • v-dineshya's avatar
    v-dineshya
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi maamirkhan2023 ,

    We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

     

    Regards,

    Dinesh

    • v-dineshya's avatar
      v-dineshya
      Icon for Community Support rankCommunity Support
      1 year ago

      Hi @maamirkhan2023 ,

      We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

       

      Regards,

      Dinesh

      • v-dineshya's avatar
        v-dineshya
        Icon for Community Support rankCommunity Support
        1 year ago

        Hi @maamirkhan2023 ,

        We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

         

        Regards,

        Dinesh