Total Involvements

[nshaw75]

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

[nshaw75]

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.

[davidding]

@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.

[davidding]

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])

        )

    )

)