The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello
I have the following matrix where the Rows are the Mission Project Field, the column is the Row field and the Values is the following DAX
@amitchandak @tamerj1 @danextian @goncalogeraldes @v-tangjie-msft @v-kaiyue-msft @Uzi2019
Solved! Go to Solution.
@spandy34 You didn't use my code. Your code has syntax errors and will not work because it is not the correct logic. Use exactly this:
z_Names_Matrix = CONCATENATEX( DISTINCT( 'Name Main'[Name] ) , [Name], "," & UNICHAR(10))
@spandy34 Try:
z_Names_Matrix = CONCATENATEX(
DISTINCT('Name Main'[Name]),[Name],"," & UNICHAR(10))
Thank you for your response. I get the following error when I insert DISTINCT as you suggest
@spandy34 You didn't use my code. Your code has syntax errors and will not work because it is not the correct logic. Use exactly this:
z_Names_Matrix = CONCATENATEX( DISTINCT( 'Name Main'[Name] ) , [Name], "," & UNICHAR(10))
Thank you very much - that has worked. Sorry about not copying the DAX properly. I appreciate your time.
User | Count |
---|---|
12 | |
9 | |
6 | |
6 | |
6 |
User | Count |
---|---|
24 | |
14 | |
14 | |
9 | |
7 |