cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## Generating dynamic rows and counting them

Hi all,

I have been struggling with my dax function to generate for each row a value 1 then calculte the sum, however whenever I add another field in my table the total should increase but it stays the same.

Is there a dynamic way to simply generate this 1 for each new row with the sum of all of them?

Here is what I am using, there are some cells blank as well.

 Product Id product Name Market price Cout Tv-123 Tv store 1 1 Tv-325 Tv online 2 1 PS4-456 PS4 1 PS4-247 ps4 2 1 Total 5 4

Whenever I add other columns to this table as here below, I keep on seeing the 1 but the total stays the same

 Product Id product Name Market size Price count Tv-123 tv online 10 0.5 1 Tv-123 tv online 5 0.5 1 Tv-123 tv online 8 1 1 Tv-123 tv online 6 1 1

thanks!

1 ACCEPTED SOLUTION
Community Support

Hi @ybyb23 ,

There are two reasons which may cause numeric fields not automatically summed:

2, There is a modeling relationship.

According to your description, I created a sample, and here is my solution.

Create a column.

``````count =
IF (
COUNTROWS (
FILTER (
'Sheet1',
'Sheet1'[Product ID] = EARLIER ( 'Sheet1'[Product ID] )
&& 'Sheet1'[Product Name] = EARLIER ( 'Sheet1'[Product Name] )
&& 'Sheet1'[Market] = EARLIER ( 'Sheet1'[Market] )
&& 'Sheet1'[price] = EARLIER ( 'Sheet1'[price] )
&& 'Sheet1'[size] = EARLIER ( Sheet1[size] )
)
) > 0,
"1",
BLANK ()
)
``````

When you add rows to the table, you will get the final output.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ xiaosun

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

4 REPLIES 4
Community Support

Hi @ybyb23 ,

There are two reasons which may cause numeric fields not automatically summed:

2, There is a modeling relationship.

According to your description, I created a sample, and here is my solution.

Create a column.

``````count =
IF (
COUNTROWS (
FILTER (
'Sheet1',
'Sheet1'[Product ID] = EARLIER ( 'Sheet1'[Product ID] )
&& 'Sheet1'[Product Name] = EARLIER ( 'Sheet1'[Product Name] )
&& 'Sheet1'[Market] = EARLIER ( 'Sheet1'[Market] )
&& 'Sheet1'[price] = EARLIER ( 'Sheet1'[price] )
&& 'Sheet1'[size] = EARLIER ( Sheet1[size] )
)
) > 0,
"1",
BLANK ()
)
``````

When you add rows to the table, you will get the final output.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ xiaosun

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

Frequent Visitor

thank you very much for your support. It worked perfectly!

Also I have approched it differently with the summerize function  I have added all the fields name to count and it worked.

Super User

Souunds like you want to inspect your data model.  Same value in all rows usually points to a mis-picked column from the wrong side of the relationship.

Frequent Visitor

Hi @lbendlin

what I was trying to do is to see if the number of rows are correct to calculte a % based on another condition 🙂

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors