First you should create a virtual table with the customers and the number of locations. Then you can summarize by company. The following measure is doing that and should solve your problem: Number of Locations V2 = -- Create a virtual table of the distinct Customer Values and add the maximu...
DAX SUMMARIZE Help - works only with 01 field from table, but when we Add the second stops to work 11-30-2022 11:04 AM Hi,I have a table with too many records, we need distinct values for a selected period on a slicer. If you take a look the image below, ...
A column of unique values. Remarks The results of DISTINCT are affected by the current filter context. For example, if you use the formula in the following example to create a measure, the results would change whenever the table was filtered to show only a particular region or a time period...
Apply the VALUES function VALUES returns a one-column table that contains the distinct values from the specified table or column; duplicate values are removed and only unique values are returned. For example, you just got handed a task where you need to show which player on a sports team has...
DAX includes many functions that return a table rather than a value. The table is not displayed, but is used to provide input to other functions. For example, you can retrieve a table and then count the distinct values in it, or calculate dynamic sums across filt...
Now I can see there are 9 values for Selling Area Size. As I suspected, this is a way to group stores by size. In SQL, this DAX query is the same as: SELECT DISTINCT Store.SellingAreaSize FROM Store I now wonder how many stores we have by each Selling Area Size. In this data ...
DAX includes many functions that return a table rather than a value. The table is not displayed, but is used to provide input to other functions. For example, you can retrieve a table and then count the distinct values in it, or calculate dynamic sums across fi...
DAX Measure - Number of distinct values from delimited string 08-09-2017 09:25 PM I have a table like the following: Date Visited Customers 2017-AUG-01 Bobby,John,Richard,Felicia 2017-AUG-02 Albert,John I want to have a measure that calculates number of unique custo...
DAX includes many functions that return a table rather than a value. The table isn't displayed, but is used to provide input to other functions. For example, you can retrieve a table and then count the distinct values in it, or calculate dynamic sums across filtered tables or columns. DAX...
DAX includes many functions that return a table rather than a value. The table isn't displayed, but is used to provide input to other functions. For example, you can retrieve a table and then count the distinct values in it, or calculate dynamic sums across filtered tables or columns. DAX...