Forum Discussion

Motwi's avatar
Motwi
Frequent Visitor
1 year ago
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...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    1 year ago

    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

v-venuppu's avatar
v-venuppu
Community Support
1 year ago

Hi Motwi ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.