topic Total Involvements in Service

Total Involvements

nshaw75 — Sat, 13 Jul 2024 09:17:18 GMT

Hi guy's I am a bit stuck on an issue. I have visual set up, originally I did it in the Desktop experience, but when I uploaded it to a shared site it now forces me to us it in the Online Service site. The visual is based on a SharePoint list of Permits and I have a column for Raiser and a column for Authoriser. What I am looking to do is create a chart which has total involvements, ie if a team member is either the raiser or the authouriser.

I have asked co-pilot and they say I need to create a measure in DAX, an I have no idea how to do this.

Any helkp would be greatly appreciated

Re: Total Involvements

davidding — Sun, 14 Jul 2024 04:29:42 GMT

something like this might work. You need to look up a youtube video about how to create a measure using DAX. even if this does not give you the exact answer, you might be able to ask a better question to gpt again 😉

Total Involvments =
COUNTROWS(

DISTINCT(

UNION(

VALUES(table_name[Raiser]),

VALUES(table_name[Authoriser])

)

Re: Total Involvements

nshaw75 — Sun, 14 Jul 2024 14:28:41 GMT

Hi davidding

Thanks for the reply 🙂 I have created the measure as below, I had got the Column titles wrong so I have therefore used the correct ones in the DAX formula. The measure is now in my data pane.

I am struggling to understand the best way to configure the chart as each way I put the data in, it doesn't work. The only field the Measure seems to be able to go is the Y axis then in the x Axis I can put almost everything else but it doesn't show what I want it to see.

Re: Total Involvements

davidding — Mon, 15 Jul 2024 07:37:14 GMT

nshaw75 , probably checkout some dashboard design. you can also use it in card visual or bar chart that doesn't require placing that in the y-axis.