The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have a matrix with multiple values, to minimize the size I would like to add measures into each other.
For example I have a measure for a MAT Value calculation and one for a MAT index calculation.
What I need is an output like this: 45.555 (110) --> MAT value (Mat index)
Is this possible?
Solved! Go to Solution.
@Mhrnjic ok, then please adjust the measure like this
MAT index = ROUND([MAT Value]/[MAT LY Value]*100,0)
MAT index =
ROUND(
[MAT Value]/[MAT LY Value]*100
,0
)
and for the concat please use the first I posted
Concat Measures =
Round([MAT Value],4)
& " ("
& [Mat Index]
& ")"
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Then you have to put the round function into the Index Measure. If you do not knwo how can you please show the index ,measure?
@Mhrnjic ok, then please adjust the measure like this
MAT index = ROUND([MAT Value]/[MAT LY Value]*100,0)
MAT index =
ROUND(
[MAT Value]/[MAT LY Value]*100
,0
)
and for the concat please use the first I posted
Concat Measures =
Round([MAT Value],4)
& " ("
& [Mat Index]
& ")"
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Thanks!
Only struggling now with the formatting as it misses a thouasand seperator and is seen as a text. But I'll try to figure something out.
Hi @Mhrnjic ,
Pleas try the following
Concat Measures =
Round([MAT Value Measure],4)
& " ("
& [Mat Index Measure]
& ")"
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Just one question, as it seems to work. Normally my MAT value and index are number based on whole numbers, but now the outcome is with 10 decimals. How can I fix this as your measure seems to be limited to a text field?
Hi @Mhrnjic
you can round it with zero decimal values.
Concat Measures =
Round([MAT Value Measure],4)
& " ("
& Round([Mat Index Measure],0)
& ")"
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Won't work, probably because the mat index measure is labeled as a text with the ".
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |