Forum Discussion
mq2020
Helper III
Helper IIICreate calculated column from a calculation in a different table
Hi! I have a table (Table 1) with organisations and another table (Table 2) with users per organisation and whether they are claimin or not. I want to add a calculated column in Table 1 (in blue...
Hi mq2020 ,
Please try to create the following measure to get the flag of every organization with claim:
Org Claiming YN = VAR sumofClaimU = CALCULATE ( DISTINCTCOUNT ( 'User'[User] ), 'User'[User Claimed Y/N] = "y" ) RETURN IF ( sumofClaimU > 0, "Y", "N" )Best Regards
Rena
Hi mq2020 ,
Please try to create the following measure to get the flag of every organization with claim:
Org Claiming YN =
VAR sumofClaimU =
CALCULATE ( DISTINCTCOUNT ( 'User'[User] ), 'User'[User Claimed Y/N] = "y" )
RETURN
IF ( sumofClaimU > 0, "Y", "N" )Best Regards
Rena
mq2020Helper III
Helper IIIThank you so much Anonymous !
I actually applied the same to a calculated column istead of measure so that I could use the column to split my line chart using the Legend Box and use the grouping in slicers which the measure wasnt allowing me to do.