Forum Discussion

aileenc07's avatar
aileenc07
Frequent Visitor
4 years ago
Solved

HELP WITH FILTER PLEASE

Please help, why is there an error if loading

and whenever i choose acs-discrepancy, nothing shows

M_DISCREPANCY =
switch(SELECTEDVALUE(INFRACTION[INFRACTION]),
"ACS-DISCREPANCY",SUM(INFRACTION[AD_DISCREPANCY]),
COUNTROWS(FILTER(INFRACTION,INFRACTION[INFRACTION]<>"ACS-DISCREPANCY")))
 

this is the excel file where the data comes from, there's clearly acs- discrepancy

please help how to make it show

thank you

Need Help
Tutorial Requests
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi aileenc07 ,

    Please click the View errors in the error message.

    Then in PowerQuery, an Errors in Table will appear.

    In the table, look through the error row, you will find the offending records.

    These errors are usually a data type mismatch. So you may have a situation where you have a value in a number data type column that can't be converted to number, or something similar.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi aileenc07 ,

    Please click the View errors in the error message.

    Then in PowerQuery, an Errors in Table will appear.

    In the table, look through the error row, you will find the offending records.

    These errors are usually a data type mismatch. So you may have a situation where you have a value in a number data type column that can't be converted to number, or something similar.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.