Forum Discussion

gauravnarchal's avatar
gauravnarchal
Icon for Post Prodigy rankPost Prodigy
4 years ago

Need help with Calculated Column or Measure

Hello - I need your help in creating a measure or calculated column   Show all invoice numbers and total Amounts in columns against each (Settlement) Auth. When there are multiple invoice numbers ...
Need Help
Show and Tell
gauravnarchal's avatar
gauravnarchal
Icon for Post Prodigy rankPost Prodigy
4 years ago

Hi v-chenwuz-msft  - I have tried your solution, but I am not able to get the desired results for Invoice numbers.

 

I have attached my data again for you to see. Click Here

 

Many thanks for your help in advance.

v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi gauravnarchal .Your model has some problems if you want to do this ,you should edit them like the following make sure these tables can filter by Settlement table’s AUTH field.

 

 

And this measure,but unselect the blank checkbox in the filter 

Measure =
CONCATENATEX( 'ARInvoices', [invoice number], "/" )

 Pbix in the end.

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.