Forum Discussion
Count distinct values in one column, grouped by another column
I'm quite new to Power BI and I think this is probably very easy, but I've been trying to work out a solution for several days an I can't work it out. My data consists of a top-level category (un...
HI Anonymous ,
You can create a calculated column in Power BI using the following DAX measure:
Count of Type by Make = // calculated column to get count of Type by Make CALCULATE( COUNT('Model Data'[Type]), // counting the Type FILTER( 'Model Data', // filtering the table to get the count of type groupoed by Make 'Model Data'[Make] = EARLIER('Model Data'[Make]) ) )You will get the result as follows:
Hope this helps.
I've tried to apply this logic to my requirement, but am returning an error. The difference being that I want to count the number of times an individual item reference appears within a set of data:
| Part No | Date Received |
| CXV1 | 15/02/2024 |
| XC333 | 02/11/2023 |
| XC333 | 01/11/2023 |
| CXV1 | 05/10/2023 |
| ABX123 | 06/09/2023 |
| ABX123 | 04/09/2023 |
| XC333 | 11/06/2023 |
| CXV1 | 31/05/2023 |
| XC333 | 05/05/2023 |
| ABX123 | 01/04/2023 |
| ABX123 | 17/03/2023 |
| CXV1 | 03/03/2023 |
| ABX123 | 02/02/2023 |
I'm receiving an error message:
| DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values. |