Only show Dim information if parameter is correct

[Anonymous]

Hello,

What I want to create is a measure in Dim_Client that shows the data of Age, Gender, Name only if the colomn Client_Info = 1.

Example: If(Client_Info = 1 then show: Age, Gender, Name), Else (Show blank())

Access to the Power BI File:

https://www.dropbox.com/s/ap7m662l3qup8wj/Auth_Set.pbix?dl=0

Thanks!

[Mohammad_Refaei · Accepted solution]

You can create the measure likke:

_Age =
IF (
    SELECTEDVALUE ( Dim_auth[Client_Info] ) = 1,
    TOPN ( 1, VALUES ( Dim_Client[Age] ) )
)

Please check the updated file