Forum Discussion

MiKeZZa's avatar
MiKeZZa
Post Patron
9 years ago

Create Pie chart with group by

Hi all,   I have a dataset like this:   emp nr  year_month uniquenumber 161860 201702         25005 161860 201702         25006  161860 201703         25007  365630 201702         25008  365...
Need Help
MiKeZZa's avatar
MiKeZZa
Post Patron
9 years ago

Hi v-huizhn-msft thanks for you're patience.... But something goes wrong. I now have:

 

numberofcategories = CALCULATE(SUM('table name'[empnr]),ALLEXCEPT('table name','table name'[empnr],'table name'[costcenter]))

incidentcount = sum('table name'[numberofincidentsinmonth])

percentage = CALCULATE(COUNTAX(DISTINCT(SELECTCOLUMNS('table name',"empnr",'table name'[empnr],"num",'table name'[numberofcategories])),'table name'[incidentcount]),ALLEXCEPT('table name','table name'[numberofcategories]))/CALCULATE(COUNTAX(DISTINCT(SELECTCOLUMNS('table name',"empnr",'table name'[empnr],"num",'table name'[numberofcategories])),'table name'[incidentcount]),ALL('table name'))

And this results in this piechart:

 

I'm pretty sure I've done everything that you suggest, but it's clear that something is wrong.

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi MiKeZZa，

For pie visual, you select the "numberofcategories" field as Legend level, and Percent measure as value level?

 

Best Regards,
Angelia

  • MiKeZZa's avatar
    MiKeZZa
    Post Patron
    9 years ago

    No, still not good unfortionately....

     

    If I select 1 person I have this dataset:

     

    emp nr  year_month numberoftimestocount costcentre

    161860 201606         0                                    1234

    161860 201607         0                                    1234

    161860 201608         0                                    1234

    161860 201609         0                                    1234

    161860 201610         0                                    1234

    161860 201611         0                                    1234

    161860 201612         0                                    1234

    161860 201701         1                                    1234

    161860 201702         0                                    1234
    161860 201703         0                                    1234

     

    This must result in 1 person that has 1 as count. So it must be a piechart with 100% score for group '1'. But what I get is this:

     

    So it looks like he splits the data on the number of incidents, instead of summing them....

     

    Can somebody PLEASE help me?

    • MiKeZZa's avatar
      MiKeZZa
      Post Patron
      9 years ago

      I've spent a few hours this weekend but it's really hard.... Anyone with more DAX skills than me?

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        9 years ago

        Hi MiKeZZa,

        Could you please share your .pbix for further analysis?

        Best Regards,
        Angelia