Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
I'm trying to get the number of times the clients "A", "B", "C" and "D"appears in that column, but only if it has a sales in the "May" or "Jun" column.
Like:
What measure do you recommended to use?
Best regard.
Solved! Go to Solution.
hi, @Anonymous
You could use CALCULATE to evaluate an expression in a context that is modified by the specified filters.
For example:
Use these two formulas to create two measure
#May = CALCULATE(COUNTA('Table'[Clients Name]),'Table'[May]<>BLANK())+0
#Jun = CALCULATE(COUNTA('Table'[Clients Name]),'Table'[Jun]<>BLANK())+0
Result:
Best Regards,
Lin
hi, @Anonymous
You could use CALCULATE to evaluate an expression in a context that is modified by the specified filters.
For example:
Use these two formulas to create two measure
#May = CALCULATE(COUNTA('Table'[Clients Name]),'Table'[May]<>BLANK())+0
#Jun = CALCULATE(COUNTA('Table'[Clients Name]),'Table'[Jun]<>BLANK())+0
Result:
Best Regards,
Lin
@Anonymous try counta function.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |