topic Re: Grouping Table By One Column in DAX Commands and Tips

Grouping Table By One Column

NJ81858 — Fri, 15 Jul 2022 14:34:48 GMT

I am creating this table, in which every column is based on the Company Name. For some reason all of my other columns are showing the same values throughout the table. I just want to have each column to populate based on the Company Name for each particular row.

Re: Grouping Table By One Column

Anonymous — Fri, 15 Jul 2022 15:12:57 GMT

Try put all your formulas in a CALCULATE Function also, you should remove all the filters exept the company name, something like this:

Average Days = CALCULATE( AVERAGE(your_table[your_column]), ALLEXCEPT(your_table,your_table[Company Name]))

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

Re: Grouping Table By One Column

NJ81858 — Fri, 15 Jul 2022 15:26:04 GMT

I changed the way that the date is calculated to be this and it still shows up as the same for each company name.

Re: Grouping Table By One Column

Anonymous — Fri, 15 Jul 2022 16:30:51 GMT

Coult you share you PBI file so that we can take a look? If you want you can DM me

Re: Grouping Table By One Column

v-easonf-msft — Tue, 19 Jul 2022 02:17:05 GMT

Hi， NJ81858

Your new grouping table doesn't apear to have a relationship with table 'ACH Trans-INITATED' (based on field 'CompanyName') .

Please try formula like:

Date = CALCULATE ( LASTDATE ( 'ACH Trans-INITATED'[Batch Date Initiated] ), FILTER ( 'ACH Trans-INITATED', 'Grouping Table'[Company Name] = 'ACH Trans-INITATED'[Company Name] ) )

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.