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

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

Still same issue as above screenshot

grazitti_sapna's avatar
grazitti_sapna
Icon for Super User rankSuper User
1 year ago

Hi maamirkhan2023,

 

Let's try other ways to fix it,

Instead of COUNT() or DISTINCTCOUNT() directly, wrap it inside SUMX for row-level precision

Correct IP Count =
IF(
HASONEVALUE(Q_Host_List_Detection_HOSTS[Asset Tags]),
CALCULATE(COUNT(Q_Host_List_Detection_HOSTS[IP])),
SUMX(
VALUES(Q_Host_List_Detection_HOSTS[Asset Tags]),
CALCULATE(COUNT(Q_Host_List_Detection_HOSTS[IP]))
)
)

Alternate: DISTINCT IPs per Asset Tag

Correct Distinct IPs =
IF(
HASONEVALUE(Q_Host_List_Detection_HOSTS[Asset Tags]),
DISTINCTCOUNT(Q_Host_List_Detection_HOSTS[IP]),
SUMX(
VALUES(Q_Host_List_Detection_HOSTS[Asset Tags]),
CALCULATE(DISTINCTCOUNT(Q_Host_List_Detection_HOSTS[IP]))
)
)

 

If still it's not working try with this,

 

Correct IP Count =
IF(
ISINSCOPE(Q_Host_List_Detection_HOSTS[Asset Tags]),
COUNT(Q_Host_List_Detection_HOSTS[IP]),
SUMX(
VALUES(Q_Host_List_Detection_HOSTS[Asset Tags]),
CALCULATE(COUNT(Q_Host_List_Detection_HOSTS[IP]))
)
)

 

Mark this as a solution if the issue get's fixed

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

    same issue

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

    I use this dax but same issue 

    IF(
    ISINSCOPE(Q_Host_List_Detection_HOSTS[Asset Tags]),
    COUNT(Q_Host_List_Detection_HOSTS[IP]),
    SUMX(
    VALUES(Q_Host_List_Detection_HOSTS[Asset Tags]),
    CALCULATE(COUNT(Q_Host_List_Detection_HOSTS[IP]))
    )
    )