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 hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.

Thank you.