Grouping Table By One Column

[NJ81858]

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.

[Anonymous]

Hi

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! 🙂

[NJ81858]

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

[v-easonf-msft · Accepted solution]

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.

[Anonymous]

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