Paramerter does not get converted to currency from sting in power bi

[Asmasm]

I have a table with invoice amount as currency column but when added to parameter it automatically gets converted to text

OpenParameter =

VAR InvoiceLabel = "INV"

)

RETURN {

    (InvoiceLabel & " Count#", NAMEOF('ARAging'[Invoice Count]), 0),

    (InvoiceLabel & " Amount",NAMEOF('ARAging'[Invoice Amount]), 1)

}

I added it in a table matrix it shows the correct result but did not show totals as oppsed to other columns. Your help will be much appriciated 

[Asmasm]

@uzuntasgokberk Thanks for your response!
I cannot use aggragate function as it is giving me wrong result.

[uzuntasgokberk]

Hello @Asmasm,

That means your count and amoutn columns are text data type column. So you need to change it. You can change in Power Query side or Column Tools. I show the example in Column Tools. Select your column and Column tools will be open.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[Asmasm]

No they are number and Currency. When used in parameter it gets converted to text.

[uzuntasgokberk · Accepted solution]

Hello @Asmasm,

"create a measure that aggregate the values and reference the measure in the field parameter."

Solved: Re: Field Parameters not working on numeric fields - Microsoft Fabric Community

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[uzuntasgokberk]

Hello @Asmasm,

Create a measure that related to your Count and Amount. And use field parameter based on your measure. And you will see the totals.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

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