Forum Discussion

maamirkhan2023's avatar
maamirkhan2023
Helper 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
Community Support
1 year ago

Hi maamirkhan2023 

Once again i am sending the PBIX file . Please check the file.

 

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

 

Regards,

Dinesh

maamirkhan2023's avatar
maamirkhan2023
Helper I
1 year ago

same issue  incorrect column totals in Matrix. 

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

    Hi maamirkhan2023 ,

     

    Please try below DAX code.

     

    VAR SummaryTable =
    SUMMARIZE(
    'Q_Host_List_Detection_HOSTS',
    Q_Host_List_Detection_HOSTS[Asset Tags],
    "Cnt", SUM(Q_Host_List_Detection_HOSTS[IP])
    )
    RETURN
    IF(
    HASONEVALUE(Q_Host_List_Detection_HOSTS[Asset Tags]),
    SUM(Q_Host_List_Detection_HOSTS[IP]),
    SUMX(SummaryTable, [Cnt])
    )

     

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

     

    Regards,

    Dinesh

     

     

  • maamirkhan2023's avatar
    maamirkhan2023
    Helper I
    1 year ago

    Not working and I cannot use Sum here as I mention above many times

  • v-dineshya's avatar
    v-dineshya
    Community Support
    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

  • maamirkhan2023's avatar
    maamirkhan2023
    Helper I
    1 year ago

    Table 1 contails Tags and IP
    Table 2 contains Date and I joined with ID and created Matrix table

    VAR SummaryTable =
        SUMMARIZE(
            'Q_Host_List_Detection_HOSTS',              
           Q_Host_List_Detection_HOSTS[Asset Tags],
            "Cnt", DISTINCTCOUNT(Q_Host_List_Detection_HOSTS[IP])
        )
    RETURN
    IF(
        HASONEVALUE(Q_Host_List_Detection_HOSTS[Asset Tags]),
        DISTINCTCOUNT(Q_Host_List_Detection_HOSTS[IP]),
        SUMX(SummaryTable, [Cnt])
    )
  • v-dineshya's avatar
    v-dineshya
    Community Support
    1 year ago

    Hi maamirkhan2023 ,

    Please provide sample data and  expected output. it will help me to replicate the scenario. without sample data and without expected output, we can't proceed further.

     

    Regards,

    Dinesh