Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Hi,
You can make your dax work with a small change,
Use ISFILTERED instead of HASONEVALUE:
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!
Proud to be a Super User!
Hi,
You can make your dax work with a small change,
Use ISFILTERED instead of HASONEVALUE:
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!
Proud to be a Super User!
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.
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |