Only show Dim information if parameter is correct

Anonymous — Fri, 30 Jul 2021 09:11:04 GMT

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:

Thanks!

Re: Only show Dim information if parameter is correct

Mohammad_Refaei — Fri, 30 Jul 2021 10:26:18 GMT

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