cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
paulgalve-mrm
Helper I
Helper I

Using the Original Count Instead of the Repeated Count

Hello - trying to use the TPID count column, but it repeats the count after adding the Marketing Play Product column. WHat's the measure I can create to use the original Count, instead of the repeated count?  In this example, should be 12 for High Tech Software, not 12*9(rows).

paulgalvemrm_1-1660904431017.png

 

Thanks!

PG

 

1 ACCEPTED SOLUTION

Oh I think I got it, I can calculate the denominator to get the distinct count of the repeating columns.

 

paulgalvemrm_2-1660907422108.png

Thanks!

 

View solution in original post

5 REPLIES 5
gauravtomar
Frequent Visitor

Please share the measure or formula you use in TPID count.

Well it's a measure already provided from the source.  Initially, this looks good with this fields:

paulgalvemrm_0-1660906683587.png

It is when we add the new column Marketing Play Product that the dataset expands the TPID count depending on the # of rows the Marketing Play Product has(in this case 9 rows).  I need that Marketing Play added but, when creating a new measure, I wanted to use the TPID count before the new field was added.  Is that possible?

paulgalvemrm_1-1660907014838.png

 

 

Oh I think I got it, I can calculate the denominator to get the distinct count of the repeating columns.

 

paulgalvemrm_2-1660907422108.png

Thanks!

 

gauravtomar
Frequent Visitor

Hi,
You are using a calculated column and High Tec is repeated 9 times in your data this is the reason it is showing 12 values 9 times in your data. 
you can take count in or check count in the matrix table.

@gauravtomar - thanks.  not sure though what do you mean take count in or check count in the matrix? I'm looking at using 12 as a denominator in the measure.

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.