Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ".
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
72 | |
60 | |
59 |