Forum Discussion

navneet0512's avatar
navneet0512
Icon for Helper III rankHelper III
1 year ago
Solved

Order volume divide by days selected in date filter

I want order volumn as per all the column visual devided by days or date selected in date filter(Sclicer).

 

data protection
Need Help
Show and Tell
Tips and Tricks
  • danextian's avatar
    danextian
    1 year ago

    Hi navneet0512 

    Ensure that you are using a separate dates table related to your fact. Create this measure

    DIVIDE (
[order volume],
CALCULATE ( COUNTROWS ( datestable ), ALLSELECTED ( datestable ) )
)

    Please see the attached pbix

     

4 Replies

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    1 year ago

    Hi navneet0512 

    Ensure that you are using a separate dates table related to your fact. Create this measure

    DIVIDE (
[order volume],
CALCULATE ( COUNTROWS ( datestable ), ALLSELECTED ( datestable ) )
)

    Please see the attached pbix

     

  • v-menakakota's avatar
    v-menakakota
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi navneet0512 ,

     

    May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

    Thank you

  • v-menakakota's avatar
    v-menakakota
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi navneet0512  , 

    Thanks for reaching out to the Microsoft fabric community forum. 

     

    I would also take a moment to thank  danextian , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 
    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution so that other community members can find it easily. 

    Best Regards, 
    Menaka.
    Community Support Team  

    • v-menakakota's avatar
      v-menakakota
      Icon for Community Support rankCommunity Support
      1 year ago

      Hi navneet0512 ,

       

      I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution so that other community members can find it easily


      Best Regards, 
      Menaka.
      Community Support Team