Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Numerical formats

Hello All, I am using dax measure to calculate the result for division of two counts for two columns, the issue that I always got an integer approximated result ( for example when the actual divisio...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Not sure why are you getting 1.  This is what I get.

 

 

 

 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

you are here used simply two numbers, I am using Dax calculation to divide the result of a count statement for a column by a count statement for another column!! Which didn't give me the ax act result without approximation!  

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    Dividing 2 measures also give me the formatting. Not sure why it is not showing up in your pbix.

     

     

     

     

     

    Result1 =

    var _a = FILTER(ALLEXCEPT('Table2','Table2'[Bank]), 'Table2'[ErrorType] <> BLANK())
    RETURN
    CALCULATE(DISTINCTCOUNT('Table2'[Process]),_a)
     
     
    Result2 = CALCULATE(DISTINCTCOUNT('Table2'[Process]),ALLEXCEPT('Table2','Table2'[Bank]))
     
    DivideVal = DIVIDE([Result2],[Result1])
     
     
    Below image  is for 
    DivideVal = DIVIDE([Result1],[Result2])
     
     
    Thanks
    HN
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous ,

         

        Shown both the division in the above post.

         

        Can you share some sample data and the measure formula for TAT Order and Typical Submission

         

        Regards,

        HN