Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I have a PBI table visual like in the snip below.
The table automatically include the TOTAL sum of Cost$ and Revenue$.
How can I get a TOTAL of the number of accounts (i.e. the Count of Account Names)?
I don't see such a option for the table visual.
Thank you.
Solved! Go to Solution.
Hi @ayeoh ,
You can do this by making the Account Name a measure in a table visual:
You will need that Account ID to be always on the table and not summarizing for it to work.
Hope that helps!
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
Hi @ayeoh ,
You can do this by making the Account Name a measure in a table visual:
You will need that Account ID to be always on the table and not summarizing for it to work.
Hope that helps!
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/