Forum Discussion

kp_wood13's avatar
kp_wood13
Icon for Helper I rankHelper I
3 years ago
Solved

New Measure Causing PBI to Ignore Filters

Hello, I have a table visual that I am adding two new measures to. I have the page filtered down to a dataset that returns 6 rows. When I add either of these new measures to the table, I get the full dataset back, it completely ignores any filters on the visual, page, or report. Any suggestions?

Need Help
  • vicky_'s avatar
    vicky_
    3 years ago

    Does your measure contain a table filter function? these will override slicers on the page. And other suggestions might be to look into whether you have enabled visual interactions between slicer(s) if any.

2 Replies

  • vicky_'s avatar
    vicky_
    Icon for Super User rankSuper User
    3 years ago

    Does your measure contain a table filter function? these will override slicers on the page. And other suggestions might be to look into whether you have enabled visual interactions between slicer(s) if any.

  • kp_wood13's avatar
    kp_wood13
    Icon for Helper I rankHelper I
    3 years ago

    Hello,

    I've pasted one of my measures below, I assume the SELECTEDVALUE is the table filter you're referring to?

     

    Implementation Dates = IF(ISBLANK(SELECTEDVALUE('NIKU ODF_CA_PROJECT'[app_tar_imp_date])),"","1-" & FORMAT(MAX('NIKU ODF_CA_PROJECT'[app_tar_imp_date]),"Short Date") & UNICHAR(10)) & IF(ISBLANK(SELECTEDVALUE('NIKU ODF_CA_PROJECT'[phase2_date])),"","2-" &FORMAT(MAX('NIKU ODF_CA_PROJECT'[phase2_date]),"Short Date") & UNICHAR(10)) & IF(ISBLANK(SELECTEDVALUE('NIKU ODF_CA_PROJECT'[phase3_date])),"","3-" & FORMAT(MAX('NIKU ODF_CA_PROJECT'[phase3_date]),"Short Date") & UNICHAR(10)) & IF(ISBLANK(SELECTEDVALUE('NIKU ODF_CA_PROJECT'[phase4_date])),"","4-" & FORMAT(MAX('NIKU ODF_CA_PROJECT'[phase4_date]),"Short Date") & UNICHAR(10)) & IF(ISBLANK(SELECTEDVALUE('NIKU ODF_CA_PROJECT'[phase5_date])),"","5-" & FORMAT(MAX('NIKU ODF_CA_PROJECT'[phase5_date]),"Short Date") & UNICHAR(10)) & IF(ISBLANK(SELECTEDVALUE('NIKU ODF_CA_PROJECT'[phase6_date])),"","6-" & FORMAT(MAX('NIKU ODF_CA_PROJECT'[phase6_date]),"Short Date") & UNICHAR(10)) & IF(ISBLANK(SELECTEDVALUE('NIKU ODF_CA_PROJECT'[phase7_date])),"","7-" & FORMAT(MAX('NIKU ODF_CA_PROJECT'[phase7_date]),"Short Date") & UNICHAR(10)) & IF(ISBLANK(SELECTEDVALUE('NIKU ODF_CA_PROJECT'[phase8_date])),"","8-" & FORMAT(MAX('NIKU ODF_CA_PROJECT'[phase8_date]),"Short Date") & UNICHAR(10)) & IF(ISBLANK(SELECTEDVALUE('NIKU ODF_CA_PROJECT'[phase9_date])),"","9-" & FORMAT(MAX('NIKU ODF_CA_PROJECT'[phase9_date]),"Short Date") & UNICHAR(10)) & IF(ISBLANK(SELECTEDVALUE('NIKU ODF_CA_PROJECT'[phase10_date])),"","10-" & FORMAT(MAX('NIKU ODF_CA_PROJECT'[phase10_date]),"Short Date") & UNICHAR(10)) & IF(ISBLANK(SELECTEDVALUE('NIKU ODF_CA_PROJECT'[phase11_date])),"","11-" & FORMAT(MAX('NIKU ODF_CA_PROJECT'[phase11_date]),"Short Date") & UNICHAR(10)) & IF(ISBLANK(SELECTEDVALUE('NIKU ODF_CA_PROJECT'[phase12_date])),"","12-" & FORMAT(MAX('NIKU ODF_CA_PROJECT'[phase12_date]),"Short Date") & UNICHAR(10)) & IF(ISBLANK(SELECTEDVALUE('NIKU ODF_CA_PROJECT'[phase13_date])),"","13-" & FORMAT(MAX('NIKU ODF_CA_PROJECT'[phase13_date]),"Short Date") & UNICHAR(10)) & IF(ISBLANK(SELECTEDVALUE('NIKU ODF_CA_PROJECT'[phase14_date])),"","14-" & FORMAT(MAX('NIKU ODF_CA_PROJECT'[phase14_date]),"Short Date") & UNICHAR(10)) & IF(ISBLANK(SELECTEDVALUE('NIKU ODF_CA_PROJECT'[phase15_date])),"","15-" & FORMAT(MAX('NIKU ODF_CA_PROJECT'[phase15_date]),"Short Date"))