Measure(s)? - Count of Values that meet Calculated Results

TitansGO

New Member
Joined
Aug 3, 2016
Messages
7
Office Version
  1. 365
Platform
  1. Windows
I’m attempting to come up with a DAX expression that enables me to see how many values meet a specified result. E.g., I have two columns in an evaluation named DATE and PRODUCT. I want to create a visual that shows how many DISTINCT PRODUCTS show up on a COUNT of DATES. I've made a quick chart to show my expected result. To be clear, if a unique product appears across 2 unique DATES, then I want it to be counted in the result of 2 in the chart below.

1628622678306.png
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
I've found a better way to describe what I need done on this one. What I'm looking for is a frequency distribution table of how many times a distinct PRODUCT appears on a DATE . E.g., if product A appears on 3 reports, then it'd have frequency of 3 and fall within the bin of 3. I'd expect the same result as above. I'm having trouble figuring out the DAX to create the measure to start the binning, I think? The only videos I've seen explain the process is when they reference a column of numerical values that is subject to normal aggregation math, which does not apply to me as I'm looking to apply to PRODUCTS or unique IDs. Any help or direction is appreciated.
 
Upvote 0

Forum statistics

Threads
1,223,702
Messages
6,173,961
Members
452,539
Latest member
delvey

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