Forum Discussion

NJ81858's avatar
NJ81858
Helper IV
4 years ago
Solved

Grouping Table By One Column

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...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    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's avatar
Anonymous
Not applicable
4 years ago

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's avatar
NJ81858
Helper IV
4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    4 years ago

    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.