Forum Discussion

vishalbaldania's avatar
vishalbaldania
Icon for Helper I rankHelper I
9 years ago

Total Count Without Duplicates

vanessafvg    How to Count total number of rows in table after using some filter. I have created column and Measure to calculate number of rows in table but could not get right result.   As you c...
Need Help
vishalbaldania's avatar
vishalbaldania
Icon for Helper I rankHelper I
9 years ago

vanessafvg

As you said i created Measure A and it's works but I can't see the total rows on the bottom. Might be becasue of i used distictcount if i use something else like count or countrows it does not works

 

 

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

vishalbaldania ok but can you tell me what you expect to see there?  because i dont quite understand the issue here,what is the expected value at the bottom the total is going to return a distinct count of all equipment ids, it look  like you only have one equipment id in your table.

 

i am not quite sure what you objective is, if you explain the business requirement mabye i can help you better