Forum Discussion

Mbuhary_AOud's avatar
Mbuhary_AOud
New Member
3 years ago

Refer to a Calculated Measure in Tabular Editor inside a Calculation Item Expression

Hi All,   Is there a way to refer to a "Calculated Measure" while we write an expression of a "Calculation Item" in Tabular Editor ? I am trying to build a calculation where I need a "Specific Tex...
Tabular Editor
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi , Mbuhary_AOud 

According to your description, do you mean you want to use the measure created in the Power BI Desktop in your calculated group's item?

I test it in my side , i think you can just use it as the same in Power BI .

This is the measure in my Power Bi Desktop:

Measure in Desktop = CALCULATE( MAX('Table'[Value]) , ALL('Table'))
 
Then i create a calcualted item in Tabular Editor:
var _measure = [Measure in Desktop]
return
selectedmeasure()+_measure
 
The selectedmeasure() means which the measure you put on the visual value.

 

 

Then we can put the field on the visual to test , the result is as follows:

 

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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

 

Mbuhary_AOud's avatar
Mbuhary_AOud
New Member
3 years ago

Hi Aniya

Thank you for your response.

I have created the Calculated Measure inside Tabular Editor, so it resides in the same Tabular Editor Calculation Group.

I am looking refer to it in my Calculation Item.

Have you tried something like that...

BR,

Imran

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi , Mbuhary_AOud 

    Thanks for your quick response ! Do you mean you need to use the calculated item in the same calculated group?

    For an example , you want to use the [Type] in the [New Calculation]?
    If this , i think you can not just use it directly . In my understand , the calculated group is used to expnad the dimension for the current measure. And for each item has their own contect filter in this visual and do not affect each other.

    So , we can not just use the 'Calculated Group'[Item] to use it in the other Item.

    If you want to use the other value , i think you need to copy the whole dax code in this item as a parameter using the "VAR" to define it.

     

    The result is as follows:

     

     

    By another , in my understand , we can not also use the other item in the differnt calculated group.

     

     

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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

     

     

    • Mbuhary_AOud's avatar
      Mbuhary_AOud
      New Member
      3 years ago

      I am sorry for not making it clear.

      I know how to use one "Calculation item" inside another "Calculation item".

      Here my question is how to use "Calculated Measure" inside a Calculation item.

      Provided the calculated measure is created in Tabular Editor and not in Desktop.
      Hope its clear now.

      • v-yueyunzh-msft's avatar
        v-yueyunzh-msft
        Icon for Community Support rankCommunity Support
        3 years ago

        Hi, Mbuhary_AOud 

        Thanks for your quick response! Do you mean you create a measure in the Tabular Editor? And you want to use this measure in the calculated Item?

        As you can  just drag it to the expression box and use the [Measure Name] in it :

         

         

        If i do not understand your need , you can give the detailed steps in your side .

         

        Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

         

        Best Regards,

        Aniya Zhang

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