Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I could not find a solution online, however I'm sure there is an simple answer to this.
I have a measure that checks if a given location had any sales. Sales Y/N =if([!Sales API]>0,1,0), now if you put it to table it will show 1, but if you put it with location names it will, show 0 or 1 e.g.
Location | Sales Y/N |
London | 1 |
Berlin | 0 |
My location table has over 1000 locations, so I'd like to be able to create a measure that will count all 1 for all avaiable locations, so I can use it in a card visual.
I've tried Sales Check = calculate([Sales Y/N]=1,filter('Shared'[Location]) but it does not work. Any suggestions ?
Solved! Go to Solution.
Hi @misiek5510 ,
Based on your description, I have created a simple sample:
Please try:
Measure = SUMX(SUMMARIZE('Table','Table'[Location],"Count",[Sales Y/N]),[Count])
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @misiek5510 ,
Based on your description, I have created a simple sample:
Please try:
Measure = SUMX(SUMMARIZE('Table','Table'[Location],"Count",[Sales Y/N]),[Count])
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much. Worked immidetaly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
124 | |
79 | |
50 | |
38 | |
38 |
User | Count |
---|---|
195 | |
80 | |
70 | |
51 | |
42 |