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.

     

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
       )