Forum Discussion

rajiv_tarafdar's avatar
rajiv_tarafdar
Helper I
8 years ago
Solved

Using Measures in Another Measure

Hi Guys,    I need to calculate a measure from the selected values of the same Measure.  I need to calculate what portion of sales people are internal of the total sales count i.e. Inter Sales Cou...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Highlight your measure in the field list and then use the Modelling tab in Power BI Desktop to change.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Please ensure that all those formulas are measures and not calculated columns.

rajiv_tarafdar's avatar
rajiv_tarafdar
Helper I
8 years ago

Hi Ashish_Mathur

 

INTERNAL and %INTERNAL are measures. Rest are columns direct from the data source. 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    Try this measure

     

    =CALCULATE(SUM(F_SALES[COUNT]),D_SALES[PERSON_TYPE] = "Internal")/SUM(F_SALES[COUNT])

     

    Does this work?

    • rajiv_tarafdar's avatar
      rajiv_tarafdar
      Helper I
      8 years ago

      Nope, same results 0 / 1

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        Hi,

         

        Share the link from where i can download your PBI file.