Forum Discussion
Helper IIncorrect Column Totals in Matrix showing
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
Helper Isame Issue I already replied
Community SupportHi maamirkhan2023 ,
You are getting incorrect column totals in Matrix. In my response , I have provide screenshot and PBIX file, please refer below snap, it will show the correct column totals in Matrix.
For example ,if we consider "Tag1" from "January" to "July" , the column total value is "843".
17+717+6+50+24+11+18= 843. I think this is your expected output.
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
- maamirkhan2023
Where is PBIX file can you please share again
- maamirkhan2023
Yes but Where is PBIX file can you please share again and what will be dax
- maamirkhan2023
I try this Dax and your dax but same issue
VAR SummaryTable =SUMMARIZE('Q_Host_List_Detection_HOSTS',Q_Host_List_Detection_HOSTS[Asset Tags],"Cnt", DISTINCTCOUNT(Q_Host_List_Detection_HOSTS[IP]))RETURNIF(HASONEVALUE(Q_Host_List_Detection_HOSTS[Asset Tags]),DISTINCTCOUNT(Q_Host_List_Detection_HOSTS[IP]),SUMX(SummaryTable, [Cnt]))- v-dineshya
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
same issue incorrect column totals in Matrix.