Forum Discussion

StuartSmith's avatar
StuartSmith
Power Participant
3 years ago
Solved

Final Calculated Column is displaying incorrect results. (Example .pbix file included)

I have "Merged" various columns from 3 tables into a table called "Table: All Absence Details".   I then created a "Table Visual" using columns (including "Absence Start Date") from the table "Tabl...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    StuartSmith , A calculated column can not use slicer values a measure can, you have to create a measure

     

    Absence KPI = IF(SELECTEDVALUE('Table: All Absence Details'[Fully Backfilled]) = "Yes", "KPI Met", "KPI Breached")

     

    In case you need a slicer on that, you need segmentation 

     

    very similar to this one

    Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q

     

     

amitchandak's avatar
amitchandak
Super User
3 years ago

StuartSmith , A calculated column can not use slicer values a measure can, you have to create a measure

 

Absence KPI = IF(SELECTEDVALUE('Table: All Absence Details'[Fully Backfilled]) = "Yes", "KPI Met", "KPI Breached")

 

In case you need a slicer on that, you need segmentation 

 

very similar to this one

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q

 

 

  • StuartSmith's avatar
    StuartSmith
    Power Participant
    3 years ago

    Thanks Amit, I had already tried the measure approach you suggested, and that gives the desired results, but then the silcer filter doesn't filter the table visual.  I will take a look at your link.