Forum Discussion
Solved
Summarize columns and count the rows
Hi,
I summarized the result below with query
Test = SUMMARIZECOLUMNS(
Metier[id], Metier[accountid_value],Metier[actualclosedate],Metier[jav_name],"COUNT",IGNORE(COUNT(Metier[jav_name])
))
| id | accountid_value | COUNT | jav_name | actualclosedate |
| 906e9740-02f4-e811-a950-000d3a45413b | f3ceefd6-7aa7-e711-8111-e0071b652f71 | 2 | Audit | 11/3/2021 12:00:00 AM |
| fc4f127a-70e7-e911-a812-000d3a252d60 | f3ceefd6-7aa7-e711-8111-e0071b652f71 | 1 | Conseil | 7/9/2021 12:00:00 AM |
| 8c6e9740-02f4-e811-a950-000d3a45413b | f3ceefd6-7aa7-e711-8111-e0071b652f71 | 1 | Expertise Comptable & Gestion | 7/7/2021 12:00:00 AM |
| 8c6e9740-02f4-e811-a950-000d3a45413b | f3ceefd6-7aa7-e711-8111-e0071b652f71 | 1 | Expertise Comptable & Gestion | 9/2/2021 12:00:00 AM |
| 906e9740-02f4-e811-a950-000d3a45413b | f3ceefd6-7aa7-e711-8111-e0071b652f71 | 1 | Audit | 10/29/2021 12:00:00 AM |
| 906e9740-02f4-e811-a950-000d3a45413b | 0001fd48-aa38-ec11-8c64-000d3ab97248 | 1 | Audit | 10/29/2021 12:00:00 AM |
| fc4f127a-70e7-e911-a812-000d3a252d60 | f3ceefd6-7aa7-e711-8111-e0071b652f71 | 1 | Conseil | 8/6/2021 12:00:00 AM |
here based on the "Audit" -> id,accountid_value and jav_name (Audit) are 3 count. But the date are different in one row. I would like to display the date column and count as 3 even if date is different
Please advise;
Thanks
Vinoth
Vinothsusai Perhaps try a CALCULATE with an REMOVEFILTERS for the date?
2 Replies
Vinothsusai Perhaps try a CALCULATE with an REMOVEFILTERS for the date?
