Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculate Individual Client vs Client Sector vs All Clients

Hi, I am hoping someone can help me with a measure I am looking to build.   I have a dashboard which has a slicer for client names.   I want to build a measure which looks at the Time to Submi...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi Anonymous ,

     

    Please try the following formula:

     

    Avg_Industry = 
VAR tab =
    SUMMARIZE (
        ALL ( client ),
        client[Customer ID],
        client[Industry],
        "s", [Time to Submit]
    )
RETURN
    AVERAGEX ( FILTER ( tab, [Industry] = MAX ( client[Industry] ) ), [s] )
    Avg_Total = 
AVERAGEX ( ALL ( client ), [Time to Submit] )

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

sturlaws's avatar
sturlaws
Icon for Resident Rockstar rankResident Rockstar
4 years ago

Hi,

 

the Industry average-measure can be written like this:

 

industry_average =
VAR _industry =
    CALCULATE ( SELECTEDVALUE ( 'DimCustomer'[Industry] ) )
RETURN
    AVERAGEX (
        FILTER ( ALL ( DimCustomer ), DimCustomer[Industry] = _industry ),
        [Avg Time to Submit]
    )

 


Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi sturlaws ,

    Thanks for you help although I can't seem to get the measure to calculate correctly.

    When I select a client I am able to see the measures specific to just the client and compare this to all clients, however the industry comparison is blank (See below):

     

    When I have no client selected in my measure I can see that for the industry comparative the values remain the same 

    Any idea's what might be causing this?

     



     

    • sturlaws's avatar
      sturlaws
      Icon for Resident Rockstar rankResident Rockstar
      4 years ago

      If you are in need of more assistance, you need to provide more information about your data, your model and your model. Preferably by creating a sample report which replicates your issues, and sharing that(upload to some cloud storage, and share the link)

      How to Get Your Question Answered Quickly