cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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.

Anonymous
Not applicable

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

 

 

Anonymous
Not applicable

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.

Anonymous
Not applicable

@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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.