How to show total of rows in a table visual under a string column

[VictorDAX]

Hello,

I would like to display the number of rows in my table in the total row under a string column.

I have created a measure like this:

BuildingAndTotal = IF(HASONEVALUE(FactSales[Building]),SELECTEDVALUE(FactSales[Building]),COUNTROWS(FactSales))

But when I use only this measure, the Year column and TotalSales in my table, the detail of the sites disappears.
I would like to keep this detail, how to do ?

In the Expected table on the screenshot, I have left the Buidling column but I have hidden it. I would like to know if it is possible to have the same result as this table without leaving this column?

And I would also like the number of rows to appear as a whole number without the decimals. Is this possible?

Thank you for your help,

Victor

[ValtteriN · Accepted solution]

Hi,

You can make your dax work with a small change,
Use ISFILTERED instead of HASONEVALUE:

BuildingAndTotal = IF(ISFILTERED(FactSale[Building]),SELECTEDVALUE(FactSale[Building]),COUNTROWS(FactSale))

End result:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[VictorDAX]

Thank you for your reply, will try!

In your screenshot your using a different measure from your text :

BuildingAndTotal = IF(ISFILTERED(FactSale[Year]),MAX(FactSale[Building]),COUNTROWS(FactSale))

Could you explain why you use ISFILTERED on Year column and why you use MAX instead of SELECTEDVALUE ? To be able to get the correct syntax first try next time.