Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Flag based on the occurrences

I have a table(Name Table : accounts) which is mapped with many other tables in the direct model. In the accounts table , a column has duplicate values in it . I need create a measeaure to calculate ...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Anonymous ,

     

    If you do not want to give the zero count flag N, you try to  change the measure to following

     

    Flag =
VAR c =
    COUNTROWS ( 'EVENT PARTICIPATION DETAIL' )+0
RETURN
    IF ( c = 0, BLANK (), IF ( c > 1, "Y", "N" ) )

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

Based on my test, using variable or other function in the Filter function will reach the limitation of Directquery.

 

So try to use the following workaround what should works when table visual has only con_1 and Flag.

 

Flag = IF(COUNTROWS( 'EVENT PARTICIPATION DETAIL')>1,"Y","N")

 

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

i have remodified the given expression for inactive relationship. Can you tell me if this is correct 

 

Flag = IF(CALCULATE(COUNTROWS( 'EVENT PARTICIPATION DETAIL'),USERELATIONSHIP(ACCOUNTS[ACCOUNT_GREF],'EVENT PARTICIPATION DETAIL'[ACCOUNT_OWNER]))>1,"Y","N")