Conditional Distinct Count measure in excel pivot table

M

MrBK

New Member
Joined
Nov 25, 2020
Messages
7
Office Version
  1. 365
Platform
  1. Windows
I need help writing a distinctcount calculated measure based on conditional criteria in an excel pivot table. The data source is excel data model table titled '2023 2022 data. The two columns I'm trying to reference are the [customer name] and the [year]. The conditional formula would count distinct customers based on year = 2023. Any assistance would be greatly appreciated.
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
You must log in or register to reply here.

Similar threads

M
  • Question Question
Distinctcount with conditional criteria measure- excel pivot table
Replies
0
Views
385
MrBK
M
R
  • Question Question
Pivot Table Conditional Formatting
Replies
0
Views
177
rilzniak
R
R
  • Question Question
Data Model Error - Effecting all versions of the same workbook
Replies
0
Views
333
Rollnation3
R
A
  • Question Question
Building a nested chart using a pivot table
Replies
1
Views
343
AnthoHead
A
R
  • Question Question
Excel Creation Help
Replies
1
Views
222
awoohaw
awoohaw

Forum statistics

Threads
1,223,877
Messages
6,175,138
Members
452,614
Latest member
MRSWIN2709

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