Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Im having trouble filtering something pretty basic.
I made a measure that gives me the "Mix":
Mix =
Solved! Go to Solution.
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
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
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |