Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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/
User | Count |
---|---|
86 | |
83 | |
67 | |
61 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
84 | |
70 |