Forum Discussion

NavaneethaRaju's avatar
NavaneethaRaju
Icon for Helper IV rankHelper IV
4 years ago

All Except Issue- Find a % value using ALLEXCEPT

Hi,  I created a measure for sum the total for respective of tag, So i got a total values of indiviual tag id.there i used all except measure to create the total for the respective tag ID.  after ...
Need Help DAX measure
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

NavaneethaRaju , Have you tried

 

divide(SUM('Procedure Fact'[Procedures]), calculate(SUM('Procedure Fact'[Procedures])), all())

 

or

divide(SUM('Procedure Fact'[Procedures]), calculate(SUM('Procedure Fact'[Procedures])), allselected())