topic Switch From Sum To Count with Radio Button in Developer

Switch From Sum To Count with Radio Button

WilliamMunguti — Wed, 29 Jan 2025 08:34:56 GMT

Is there a way to switch from sum to count of a value in powerbi? and not on a chart level while creating the visual? but have a drop down that lets you select whether to sum up the values along a column or to count them

Re: Switch From Sum To Count with Radio Button

Anonymous — Thu, 30 Jan 2025 01:18:03 GMT

Hi @WilliamMunguti ,

You can do this using bookmarks or DAX, but you mentioned "not on a chart level while creating the visual", so you can only do it via DAX.

Here is my sample data:

Create another table:

And use this table to create a slicer:

Use these DAXs to create measures:

Sum = SUM('Table'[Value])

Count = COUNT('Table'[Value])

Output = SWITCH( SELECTEDVALUE(Slicer[Button]), "COUNT", [Count], "SUM", [Sum], [Sum] )

And the final output is as below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Switch From Sum To Count with Radio Button

WilliamMunguti — Fri, 31 Jan 2025 11:56:28 GMT

Hi @Anonymous
Thanks for this. Let me try it out and will give you feedback