Forum Discussion
Client-Level Security Context
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
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