Forum Discussion

bourne2000's avatar
bourne2000
Icon for Helper V rankHelper V
4 years ago

Filter visual by measure not working

Hi   I have a big data which is 3.3 million and coming from AWS Redshift. I connected through direct query   In my table I have a column called Merchant ID. I need to calculate distinct count the...
Need Help
Show and Tell
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
4 years ago

bourne2000 

Modify your 2nd measure as follows and assign it equal to 1

Flag = IF([Total Merchants] > 1, 1 , 0 )

 

 

 

  • bourne2000's avatar
    bourne2000
    Icon for Helper V rankHelper V
    4 years ago

    Fowmy Thanks. I modified the measure. However, I am not able to change the filter. It is disabled.