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

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

  • MiKeZZa's avatar
    MiKeZZa
    Post Patron
    9 years ago

    Here is the (anonymised) pbix file: Download

     

    It's (in my opinion) all about the fields used in the Pie Chart.

     

    The filtered person has 2 incidents so I expect a pie with value 2 filled for 100%.

  • MiKeZZa's avatar
    MiKeZZa
    Post Patron
    9 years ago

    Anyone an idea?