A DAX question

[AmitM]

Hi everyone,

Wonder if you can assist me with something:

My users fill a template of items and their sizes.

I am creating a dashboard to show the total consumption, and I want to scale different units into the same scale.

As an example:

<gs id="907e8fc4-e012-4664-a689-06cf40b96d31" ginger_software_uiphraseguid="337c2549-cd38-48e8-a4f9-1d1cf79e810e" class="GINGER_SOFTWARE_mark">ItemA</gs> 3 LF--> need to transform <gs id="61efa476-8da2-43bd-869f-e231680b1b54" ginger_software_uiphraseguid="337c2549-cd38-48e8-a4f9-1d1cf79e810e" class="GINGER_SOFTWARE_mark">ItemA</gs> from 3 LF to Meters.

The <gs id="97460a5f-8940-4a22-bbea-8f2905b2e9d4" ginger_software_uiphraseguid="8bad082b-c79b-449d-b541-0c782d025eb4" class="GINGER_SOFTWARE_mark">bolded</gs> measures are the measures I want to scale by...

How can this be done in PP?

[TABLE="width: 248"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD="align: left"]

*[/TD]
[TD="align: left"]Meters[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: left"]CM[/TD]
[TD="align: left"]Centimeter[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: left"]LF[/TD]
[TD="align: left"]Linear Feet[/TD]
[/TR]
[TR]
[TD="align: left"]*[/TD]
[TD="align: left"]SM[/TD]
[TD="align: left"]Square meters[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: left"]SF[/TD]
[TD="align: left"]Square Feet[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: left"]SY[/TD]
[TD="align: left"]Square Yard[/TD]
[/TR]
[TR]
[TD="align: left"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]*[/TD]
[TD="align: left"]CY[/TD]
[TD="align: left"]Cubic Yard[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: left"]CF[/TD]
[TD="align: left"]Cubic Feet[/TD]
[/TR]
</tbody>[/TABLE]

 

[olivierhbh]

Hello AmitM,

In your example "<gs id="907e8fc4-e012-4664-a689-06cf40b96d31" ginger_software_uiphraseguid="337c2549-cd38-48e8-a4f9-1d1cf79e810e" class="GINGER_SOFTWARE_mark" style="color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">ItemA</gs> 3 LF", does this represents 1 or 3 columns?

If it's just one, is the structure consistent? Item_name - space - Size - space - unit

What I would do is create a column with the unit, then add a table to your model with 2 columns, one for the unit, and the other one for the conversion coefficient to meters. Then create a relation between the 2 size columns. And then you have it, you can create a measure which would be size*coefficient to show the value in meters.

I hope it helps.

Olivier.

 

[AmitM]

Thanks a lot.

I think that I found a way to do so, using "lookupvalue"formula