cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Data from table in text measure

Hi

I have a measure with the following text:

"The value of goods on sea is " & SUM([goodsonsea])

And further down

"The value of goods in purchase orders is " & SUM([purchaseorders])

In between the two lines I would like to list the data from this table:

 Supplier Week Cll Supplier1 42 6 Supplier2 42 5 Supplier1 44 5 Supplier2 50 3 Supplier3 42 4 Supplier4 44 4

The text could be something like
"In week 42 we receive 6 cll from Supplier1 and 5 cll from supllier2 ect."

"In week 44 we receive 5 cll from Supplier1 and 4 cll from Supplier4 ect"

and so on.

I hope this give you an idea of what it is I'm looking for.

Hope you can help 🙂

Thank you.

1 ACCEPTED SOLUTION
Community Support

Hi @KLJ,

In Power BI desktop, you can create a calculated table below:

Table = var temp= SUMMARIZE('Table1',Table1[Week],'Table1'[Supplier],"con",CONCATENATEX('Table1','Table1'[Cll],","))
return

Then create a measure:

Measure 3 = var t=SUMMARIZE('Table','Table'[Week],"Detail",CONCATENATEX('Table','Table'[item]," and "))
return
CONCATENATEX(t,"In week " & [Week]& " we receive "&[Detail])

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support

Hi @KLJ,

In Power BI desktop, you can create a calculated table below:

Table = var temp= SUMMARIZE('Table1',Table1[Week],'Table1'[Supplier],"con",CONCATENATEX('Table1','Table1'[Cll],","))
return

Then create a measure:

Measure 3 = var t=SUMMARIZE('Table','Table'[Week],"Detail",CONCATENATEX('Table','Table'[item]," and "))
return
CONCATENATEX(t,"In week " & [Week]& " we receive "&[Detail])

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper I

Hi Qiuyun Yu

Thank you for the solution.

That did it 🙂

I have added UNICAR(10) at the end of

Measure 3 = var t=SUMMARIZE('Table','Table'[Week],"Detail",CONCATENATEX('Table','Table'[item]," and "))
return
CONCATENATEX(t,"In week " & [Week]& " we receive "&[Detail] & UNICHAR(10))

then it worked out exactly as I wanted. 🙂

Thanks again

Kim

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors