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!

Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

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.