cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Filtering columns in summarizecolumn

Hi

I'm trying to filter rows so that  get one value.

The Bonus (\$) is calculated by multiplying GL (\$) by 0.005

I would like to show the table so that it shows this way

 Ref# Quarter Month Sales (\$) GL (\$) Bonus  (\$) 30243770-440 2021-Q4 2021-M11 9,53034.86 96,1190.86 4,805.9543 30243770-440 2021-Q4 2021-M12 8,156.00 - -

Or maybe someone can suggest another way to display same info

1 ACCEPTED SOLUTION
Community Support

Hi  @Anonymous ,

Here are the steps you can follow：

1. Create calculated table.

``````Summarize =
SUMMARIZE('Table','Table'[Ref#],'Table'[Quarter],'Table'[Month],'Table'[Sales(\$)],
"GL(\$)",IF(RIGHT('Table'[Month],2)="12",BLANK(),MAX('Table'[GL(\$)])),
"Bounds(\$)",IF(RIGHT('Table'[Month],2)="12",BLANK(),MAX('Table'[Bouns(\$)])))``````

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Community Support

Hi  @Anonymous ,

Here are the steps you can follow：

1. Create calculated table.

``````Summarize =
SUMMARIZE('Table','Table'[Ref#],'Table'[Quarter],'Table'[Month],'Table'[Sales(\$)],
"GL(\$)",IF(RIGHT('Table'[Month],2)="12",BLANK(),MAX('Table'[GL(\$)])),
"Bounds(\$)",IF(RIGHT('Table'[Month],2)="12",BLANK(),MAX('Table'[Bouns(\$)])))``````

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.