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 meses'[Cant_CC]) +
COUNT('Data clientes lunes por 12 meses'[Cant_TC]) +
COUNT('Data clientes lunes por 12 meses'[Cant_CD]) +
COUNT('Data clientes lunes por 12 meses'[Cant_NE]) +
COUNT('Data clientes lunes por 12 meses'[Cant_PR_Vh]) +
COUNT('Data clientes lunes por 12 meses'[Cant_PR_Com]) +
COUNT('Data clientes lunes por 12 meses'[Cant_PR_Hip]) +
COUNT('Data clientes lunes por 12 meses'[Cant_PR_Tie]) +
COUNT('Data clientes lunes por 12 meses'[Cant_PR_Per]) +
COUNT('Data clientes lunes por 12 meses'[Cant_PR_LC]) +
COUNT('Data clientes lunes por 12 meses'[Cant_MC])
 
I want to make a measure where I get the amount of people (CLIENT_ID) that Mix >=2. For this i wrote the following:
 
2+ productos = CALCULATE(DISTINCTCOUNT('Data clientes lunes por 12 meses'[CLIENT_ID]),
                          FILTER('Data clientes lunes por 12 meses',[Mix]>=2)
                         )
 
Then I made a KPI visual with Date as my trend (i have an observation per day for every client) and the measure as my value.
 
Unfortunately, it didnt work. What should I do?
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

2 Replies

  • 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

  • v-lili6-msft's avatar
    v-lili6-msft
    Community 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