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

     

     

StuartSmith's avatar
StuartSmith
Power Participant
3 years ago

I'm still trying to figure this out. I have the table visual with all the column displaying and filtering apart from the "Absence KPI" measure because as soon as I add that measure, the table visual rows increases and I dont understand why.  

 

Can someone please take a look at the attached updated file and explain to me why it is doing this and how I can get around it. 

Thanks in advance.

 

Calculated Columns vs Measure Updated.pbix 

  • StuartSmith's avatar
    StuartSmith
    Power Participant
    3 years ago

    Can anyone please help with why the table visual stops filtering AND adds lots of rows once I add the "Absence KPI".  I am total lost.

    Thanks