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).
Solved! Go to Solution.
Well it's a measure already provided from the source. Initially, this looks good with this fields:
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?
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.