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 ,

 

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      It was my fault, I was forget one filter active, now everything is working. Thank you for your cooperation