Forum Discussion

Frequent Visitor

1 year ago

Matrix

Hello, I have raw data as below: - table 1: user ID month stream code: (1,2,34) whereas, within this table each user ID might be repeated within the same month based on the stream code he use...

rohit1991

Super User

1 year ago

Hi TamerOmki ,

You want to count distinct users who used each pair of stream names, using Stream Name (rows) and Stream Name1 (columns).

Solution: DAX Measure for Distinct User Count:

UserCount = 
CALCULATE(
    DISTINCTCOUNT('Table1'[User ID]),
    CROSSFILTER('Table1'[Stream Code], 'Table2'[Stream Code], BOTH)
)

Steps to Implement:

Ensure relationships: Table1[Stream Code] → Table2[Stream Code] (Many-to-One).
Create Matrix Visual:
- Rows: Table2[Stream Name]
- Columns: Table2[Stream Name1]
- Values: UserCount (above measure)