Forum Discussion

ivancespedesl's avatar
ivancespedesl
Helper 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

lc_finance's avatar
lc_finance
Solution Sage
6 years ago

Hi ivancespedesl ,

 

 

can you share an example of your Power BI with sample data?

That will make it easier to help you. You can share using OneDrive, Google Drive or a similar tool.

 

Regards

 

LC

Interested in Power BI and DAX tutorials? Check out my blog at www.finance-bi.com