Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Specify a number from a column

Hi,

 

I would like to choose a number from a column (WorkingDaysIn Month) in order to use it as a divisor. How can I do it?

 

TourRunrate = CALCULATE(COUNTROWS(TourTbl)) / *divisor*

 

Table

Need Help

3 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    Assuing you have selected a certain month in the FIlter/slicer, try this

     

    =COUNTROWS(TourTbl)/MAX(TourTbl[WorkingDaysInMonth])

     

    Hope this helps.

    • Interkoubess's avatar
      Interkoubess
      Icon for Solution Sage rankSolution Sage
      8 years ago

      Hi Anonymous,

       

      What number do you want to pick up?

       

      Please give example with you screen shot and I can make a try.

       

      Thank you.

       

      Ninter