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

New Member

## Count the Values based on dynamic rows in Matrix

We must create a Matrix using "Closed ID" as Rows & Count, Current Account Ratio, and Amount Processed as Values.

Here comes the issue, a few columns are referring to Closed ID & Few of the columns are referring to “Assigned ID”, but we Have to use only the Closed ID as rows & those Columns which are referring the “Assigned ID” Should reflect in the Closed ID Matrix.

I have attached an Excel sample with two tables & and what the result should look like. The result using Closed ID as rows & Column “Count” value is derived based on “Assigned ID”. I'm expecting the same in the  Power Bi matrix using Dax.

1 ACCEPTED SOLUTION
Community Support

Hi  @Mharipr5 ,

(1) Create a new measure

``COUNTA = CALCULATE(MAX('Table'[Count]),FILTER(ALL('Table'),'Table'[Assigned ID] = MAX('Table 1'[Closed ID])))``

(2)Final output

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

Community Support

Hi  @Mharipr5 ,

(1) Create a new measure

``COUNTA = CALCULATE(MAX('Table'[Count]),FILTER(ALL('Table'),'Table'[Assigned ID] = MAX('Table 1'[Closed ID])))``

(2)Final output

Best Regards,
Gallen Luo
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.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors