cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper IV

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

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%

1 ACCEPTED SOLUTION
Solution Sage

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.
Solution Sage

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.