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,

 

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

rajiv_tarafdar's avatar
rajiv_tarafdar
Helper I
8 years ago

Sorry Ashish_Mathur I cant share the file as its too large (650MB+) and client data. 

Here is a sanpshot of the outcome and formula

 

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    Hi rajiv_tarafdar

     

    Please use the following syntax and make sure you format the measure uses the decimal data type and at least 4 decimal points

     

    WEIGHTING = 
    DIVIDE (
        CALCUATE(SUM(F_P......) ,
        SUMIF(F_PUBLI.....) ,
        0
       )