Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filtering Issue doughnut Chart - TRICKY

Hi Experts   I am having trouble in getting the correct Yes and No values when selecting upward and or downward from the slicer within the attached pbix file.    Here is the problem when i select...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI CHerry this works

    DR = 
VAR __table = SUMMARIZE(ALL(PMS_PARTS),[Product])
VAR __table1 = ADDCOLUMNS(__table,
                 "__p-value",CALCULATE([p-value],ALL(PMS_COMPLAINT[PMSReportability])),
                        "__TAU",CALCULATE([TAU],ALL(PMS_COMPLAINT[PMSReportability])),
                                "__trend",CALCULATE([__trend],ALL(PMS_COMPLAINT[PMSReportability])))
VAR __table2 = FILTER(__table1,[__trend] = "Down")
VAR __table3 = GENERATE(SELECTCOLUMNS(__table2,"__Product",[Product]),RELATEDTABLE(PMS_COMPLAINT))
RETURN
COUNTAX(__table3,[PMSReportability])
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
6 years ago

Hi Anonymous ,

Firstly, do you only have the incorrect value when selected value is Upward?

If yes, please check if the filter condition in the UP measure is correct as I'm not clear about your logic.

In addition, by my research on your pbix, if we highlight the 404 , it will show the right value like below. 

Last but mot least, please note that do not share your actual data here, always do mask the sensitive data before uploading.

Best  Regards,

Cherry

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Cherry

if you add the following measure into the matrix table you'll the total is correct all the time. Just the Dougnut chart errors...

NO = CALCULATE(COUNTROWS(PMS_COMPLAINT),FILTER(PMS_COMPLAINT,PMS_COMPLAINT[PMSReportability]="No"))
YES = CALCULATE(COUNTROWS(PMS_COMPLAINT),FILTER(PMS_COMPLAINT,PMS_COMPLAINT[PMSReportability]="Yes"))