Table Visual get Total Rows on current selection

[Anonymous]

Hello Power BI Community,

I have a table visual as below, where Total Sign-ups is a measure, and rest columns are coming from Signups table.
My requirement is to add a column that will have 1 as a value and then show the total at the end. This table will filter records based on date and location slicers.

Can anyone please help me to get the solution

Thanks in advance

[v-luwang-msft]

Hi @Anonymous ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien 

[Ttaylor9870]

Hi @Anonymous,

Go to transorm data and then click the data tab and click on index column and you're going to want to select custom....

Then use this...

This will add the 1's to every row and hopefully this will work, ket me know if it does or not😊

Many Thanks,

Taylor

[Ttaylor9870]

Hi @Anonymous,

This DAX will work, make a new calculated column and use this...

Adding 1 Measure = IF('Table'[firstname] <> BLANK(), 1, IF('Table'[firstname] = BLANK(), 1)) ​

It bascially says if there is data in the first column or if it's blank both outcomes return a 1 in your new calculated column.

Many Thanks,

Taylor

[Anonymous]

Hi @Ttaylor9870 

This column is not helping me.
I created calculated column as suggested

Row_Counts = IF('Signups'[firstname] <> BLANK(), 1, IF('Signups'[firstname] = BLANK(), 1))

As I have multiple entries for any given firstnames, it is summing up the numbers as below:

And when filter is applied through slicer it is not bringing any values on the Table visual. 

[Ttaylor9870]

Hi @Anonymous ,

Could change the aggregation on the column from Sum to DistinctCount? Click on the table -> Go to the fields pane -> Click the small arrow on the right of the columns name -> Change from sum to Count(Distinct).

Many Thanks,

Taylor