Forum Discussion
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...
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])
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
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])Anonymous - Looks like you got it!
thanks Greg
have a great weekend and enjoy the free time before teh next book. Keep us update if the DAX book is geared more towards Data Science Calculations etc..
