Forum Discussion

nshaw75's avatar
nshaw75
New Member
2 years ago

Total Involvements

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

 

Need Help

3 Replies

  • davidding's avatar
    davidding
    Resolver I
    2 years ago

    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])
            )
        )
    )
  • nshaw75's avatar
    nshaw75
    New Member
    2 years ago

    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's avatar
      davidding
      Resolver I
      2 years ago

      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.