Filtering using a measure insidea calculate function

[ivancespedesl]

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?

[v-lili6-msft · Accepted solution]

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]

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