Forum Discussion

ivancespedesl's avatar
ivancespedesl
Icon for Helper I rankHelper I
6 years ago
Solved

Filtering using a measure insidea calculate function

Im having trouble filtering something pretty basic.   I made a measure that gives me the "Mix": Mix =  COUNT('Data clientes lunes por 12 meses'[Cant_CA]) + COUNT('Data clientes lunes por 12 ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi ivancespedesl 

    Just adjust the formula as below:

    2+ productos = CALCULATE (
    DISTINCTCOUNT ( 'Data clientes lunes por 12 meses'[CLIENT_ID] ),
    FILTER(VALUES('Data clientes lunes por 12 meses'[CLIENT_ID]),[Mix] >= 5))

    Then it should work well.

    If not your case, please share a simple sample pbix file and your expected output.

     

    Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

hi ivancespedesl 

Just adjust the formula as below:

2+ productos = CALCULATE (
    DISTINCTCOUNT ( 'Data clientes lunes por 12 meses'[CLIENT_ID] ),
    FILTER(VALUES('Data clientes lunes por 12 meses'[CLIENT_ID]),[Mix] >= 5))

Then it should work well.

If not your case, please share a simple sample pbix file and your expected output.

 

Regards,

Lin