Forum Discussion
SACooper
Helper II
Helper IIDynamic Measure, show data based on usertpe
I have a user_mappings table which lists various different pieces of infomation about users of a system, such as AD loginname, email, userprinciplename (from ad), their manager, and if they are a man...
Hi SACooper ,
My test table:
User_Mapping:
Product:
Mode:
Try below measure:
Procuet_Fruit = VAR cur_email = SELECTEDVALUE ( User_Mapping[Email] ) VAR cur_isManager = SELECTEDVALUE ( User_Mapping[IsManager_num] ) VAR cur_upn = USERPRINCIPALNAME () RETURN IF ( cur_email = cur_upn && cur_isManager = 1, CALCULATE ( MAX ( 'Product'[Fruit] ), FILTER ( 'Product', 'Product'[Email] = cur_email ) ), BLANK () )Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi SACooper ,
My test table:
User_Mapping:
Product:
Mode:
Try below measure:
Procuet_Fruit =
VAR cur_email =
SELECTEDVALUE ( User_Mapping[Email] )
VAR cur_isManager =
SELECTEDVALUE ( User_Mapping[IsManager_num] )
VAR cur_upn =
USERPRINCIPALNAME ()
RETURN
IF (
cur_email = cur_upn
&& cur_isManager = 1,
CALCULATE (
MAX ( 'Product'[Fruit] ),
FILTER ( 'Product', 'Product'[Email] = cur_email )
),
BLANK ()
)
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SACooperHelper II
Helper IIThis is brilliant thank you - think got myself working down the wrong route here but with a little tweak, this worked!