Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
I don't know what happened, but when I came back to edit my work, it didn't appear in the selection bar. SUM,COUNT,Don't Sum
About my data:
Solved! Go to Solution.
Hi @Tiger2514555
In your 1st image, please click on "Show value as"
You will get SUM, Count option
If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.
Thanks
Pijush
Proud to be a Super User! | |
Hi @Tiger2514555
Looks like in the newer version, it is not showing in the format pane
Please select the column & update from the top bar
Proud to be a Super User! | |
Hi @Tiger2514555
Can you please create and share sample pbix link here (google drive or one drive), and give access
Proud to be a Super User! | |
@PijushRoy I thank you for wasting your time. I tried another method by writing DAX, which worked without me having to select SUM,Count instead.
Hi @Tiger2514555
In your 1st image, please click on "Show value as"
You will get SUM, Count option
If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.
Thanks
Pijush
Proud to be a Super User! | |