topic Re: Count Values In Each Row (4 options) need it for stack bar chart in DAX Commands and Tips

Count Values In Each Row (4 options) need it for stack bar chart

Anonymous — Mon, 18 Apr 2022 13:28:17 GMT

Hello,

I have a ticketing system I made with four options currently. ABF, GPON, Light Green and Not available on each address that is submitted for review.

My data is coming from a sharepoint list into power bi.

I need a way to count the number of times each word is in here per "Ticket Status". (Across if that makes sense)

I will attatch a screenshot. I am trying to create a bar chart that will tell me how many were ABF, GPON, Light Green and Not available per ticket status. I will attatch photos to help with this. Basically I need to count the values for Completed.

Things to note,

I have 40 "Potential Address Results" columns #1-#40

and I have a TicketStatus Column with options unassinged, assigned, working, and completed.

Completed is the only important one here

I cannot unpivot the data

I need it to look this like... please help!

Thank you

Re: Count Values In Each Row (4 options) need it for stack bar chart

tamerj1 — Fri, 08 Apr 2022 20:46:16 GMT

Anonymous

best option is to unpivot the 40 columns using power query. Once done the rest is simple.

Re: Count Values In Each Row (4 options) need it for stack bar chart

Anonymous — Fri, 08 Apr 2022 20:49:33 GMT

tamerj1

Stupid question.. how do I do that?

What I was trying to do now was take each column something like

Calculate(Countrows( Table name ( column ) = "ABF")

But if this is easier I will totally do it! You have no idea how much you are helping me.

Re: Count Values In Each Row (4 options) need it for stack bar chart

tamerj1 — Fri, 08 Apr 2022 20:52:57 GMT

Anonymous

Open the query editor.

Select the 40 columns > right click > select unpivot

Re: Count Values In Each Row (4 options) need it for stack bar chart

v-easonf-msft — Tue, 12 Apr 2022 10:48:27 GMT

Hi, Anonymous

Could you share relevant screenshots to further clarify your question? Please save the screenshot locally before uploading,

Best Regards,
Community Support Team _ Eason

Re: Count Values In Each Row (4 options) need it for stack bar chart

Anonymous — Mon, 18 Apr 2022 13:28:34 GMT

I tried to take your advice but it broke my query. I had to contact microsoft and they could not figure it out. Do you have another option that you know of to be able to look at the filters for each column and give me a total such as this? I have 40 columns

Re: Count Values In Each Row (4 options) need it for stack bar chart

tamerj1 — Tue, 12 Apr 2022 16:41:18 GMT

Anonymous

So sorry for that!

nothing in my mind now. I will thibk it over again and let you know if any solution comes to my mind.

Re: Count Values In Each Row (4 options) need it for stack bar chart

Anonymous — Tue, 12 Apr 2022 18:16:01 GMT

Ok I appreciate it. I am going to look into how I can group the those columns together for now.

Re: Count Values In Each Row (4 options) need it for stack bar chart

Anonymous — Wed, 20 Apr 2022 14:45:32 GMT

Hey there, I am working on unpivioting the coumns. What is the next step from here?

Re: Count Values In Each Row (4 options) need it for stack bar chart

tamerj1 — Sat, 23 Apr 2022 04:14:15 GMT

Anonymous
I was going through my old notifications and just noticed that I did not reply to you. I remember I read the message but apparently forgot to reply to you. Please accept my appology. Can you please sahre a sample file to work with and explain with examples the expected results. Thanks and have a great day!