Find the count of IF condition returned 1 and have to find the late return %

[NavaneethaRaju]

Hi ,

I have column called late return its having the diffrence between two dates, and after that i write the IF condition to show the correct return Fl and late return Fl , there im showing the one and Zeros for that condition. I want to count the how many 1's are there in two columns. I have to find the difference %.

%= 15/(15+6)=71%

Please advice me to create calculated column and measure for thiss.

[mangaus1111 · Accepted solution]

Hi @NavaneethaRaju ,

to calculate the Pct of Late Return, you just need a simple measure like this:

Pct Late Return= DIVIDE(

                  CALCULATE(

                           COUNT(Table[Late Return]),

                            Table[Late Return]>0

                            ),

                 COUNTROWS('Table')

)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.