Forum Discussion
Solved
Client-Level Security Context
Hello everyone, I have a dynamic DAX measure that shows a client name (or “[REDACTED]”) based on user access defined in the firm security table. The measure works perfectly when the visual’s cont...
Motwi , do not check for blank just keep return like
IF(
AccessCount > 0,
SELECTEDVALUE(dim_Client [clientName]),
"[REDACTED]"
)
or first create a measure AccessCount and then create another measure for if logic.To use any measure on row/column, you need to do dynamic segmentaion
very similar to
Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q
Power BI ABC Analysis using Window function, Dynamic Segmentation: https://youtu.be/A8mQND2xSR4
