Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Matrix Visual To show All values for Text Field

Hi Experts,   I have one logic to be implemented. I have a table, all columns of which if taken into Power BI Table visual. We get option to select don't aggregate data for "Related_Details" colum...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous,


Can you please provide a sample pbix file to testing and coding formula?

 

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi,

 

Where can I share the PBIX file for it. 

 

Coding formula for the measure you mentioned was:

TestMeasure = CALCULATE(CONCATENATEX(VALUES(Test_Data[Related_Details]),Test_Data[Related_Details], ", "),VALUES(Test_Data[RUNTIME]),VALUES(Test_Data[Employee_Names]))

Thanks