Data Model - switch relation from inactive to active by condition.

Hi Anonymous

Which table is missing ? If you use userelationship fuction, please use the measure in the table visual or visual level filter.

Regards,

Cherie

I tried to put the measure in the table visual or visual level filter but it isn't work.

pls see the link

Hi Anonymous

I have no access to view it. Please check the updated file and let me know if it matches your request. If not, please let me know which table is not correct.

Regards,

Cherie

Hi Cherie,
I can't aggregate the data  - attach: Real Data Part 2 Sheet
I tried count default option, calculated column, measure - not work

If you can't open the attached so pls

focus on Table : score summary table by license

create column with random number 1-10
then, try to count license by this column. example:

Rand column  |    count of license column

     1                                 100 

     2                                 199

     3                                 39

     .

     .

     .

    9                                 10

   10                                20

hope for your respond

Idan

Hi Anonymous

You may change the filter to 'is not blank' if the count number is not 1.

Regards,

Cherie

Hi Cherie ,
I tried .
not working

attach - link

Idan