Forum Discussion
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...
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
I feel I over complicated this question and made the post way too long (TLDR). I have reposted the question, but simplified it down to a couple of lines, instead of a novel. 😴
New question can be found here: Why does measure stop filtering and creates additional rows