Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ivancespedesl
Helper I
Helper I

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?
1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-lili6-msft
Community Support
Community Support

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lc_finance
Solution Sage
Solution Sage

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.