Help with Dax formula

L

Limit Braker

New Member
Joined
Jun 17, 2020
Messages
13
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Hi guys,

I want to calculate the ammount of transactions that are over >=500 amount (Peruvian soles) from this big table.

SALES PERSONSKUPRODUCTSTOREINVOICE NUMBERPAYMENT METHODUNITSAMOUNT
HANDERSON ORTIZ ORUE00007680100% WHEY ISOLATE CHOCOLATE 2000 G - SNCusco
12194​
VISA
1​
349​
HANDERSON ORTIZ ORUE00007680100% WHEY ISOLATE CHOCOLATE 2000 G - SNCusco
12378​
VISA
1​
349​
HANDERSON ORTIZ ORUE00007642100% WHEY ISOLATE VANILLA 2000 G - SNCusco
12353​
EFECTIVO SOLES
1​
349​
HANDERSON ORTIZ ORUE00007635100% WHEY ISOLATE VANILLA 700 G - SNCusco
11965​
VISA
1​
159​
HANDERSON ORTIZ ORUE07051471ABS OF STEEL MAX DEF CREAM 237ML- STEELCusco
12109​
VISA
1​
139​
HANDERSON ORTIZ ORUE27023374AMINO ENERGY 1.29 LB FRUIT FUSION - ONCusco
12454​
VISA
1​
280​

I would like the output to be as follows:

StoresTransactions>500
Chacarilla
40​
Mall Arequipa
33​
Mega Plaza
20​
Real Plaza Salaverry
17​

The total transactions in one column and the ones that are above 500 in the next column.

Please help
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Sort by date Sort by votes
You must log in or register to reply here.

Forum statistics

Threads
1,223,650
Messages
6,173,599
Members
452,522
Latest member
saeedfiroozei

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top