Forum Discussion

H_Kar's avatar
H_Kar
Regular Visitor
2 years ago

Ratio

Hey Guys !  I'm trying to display a metric showing a ration. For example assume we have fields such as Active - Innactive - Completed - Cancelled - Finished.    my objective is to display finsih...
Need Help
dk_dk's avatar
dk_dk
Super User
2 years ago

Hi H_Kar ,

Assuming your data looks like this:

You can write the following measure to calculate the ratio:

 

Ratio = 

VAR finished = CALCULATE(COUNTROWS('Table'),'Table'[status]="Finished")
VAR other = CALCULATE(COUNTROWS('Table'),'Table'[status] IN {"Inactive","Cancelled","Active","Completed"})

RETURN
DIVIDE(finished,other,0)

 

 

Here I assumed that you want to calculate finished to all other statuses. If you want to calculate Active minus inactive minus completed minus calcelled, then you will just need to create multiple variables similar to the "finished" variable and then write the desired calculation in the return statement.

 

Let me know if you have any questions!

H_Kar's avatar
H_Kar
Regular Visitor
2 years ago

Hi dk_dk 

First of all, really appreciate you helping out. 

I've new measure and inserted the code you wrote, now I have it on my data (on the far right side) as "ratio1". 

 

My objective is to visualise it now - on the value I have "count of the status". Where does "ratio 1" go. I've given it several attempts however I unfortunately failed. 

 

here is a screenshot of the error message when i try to put it under "values"

 

 

  • dk_dk's avatar
    dk_dk
    Super User
    2 years ago

    Hi H_Kar 

    You can visualise the measure by adding it to a card visual (as seen on my screenshot), a table, or another chart in the values section. It would help if you can provide a screenshot to figure out what is not working. 🙂

  • dk_dk's avatar
    dk_dk
    Super User
    2 years ago

    Hi H_Kar 

    Does the measure show a calculation if you just add it to a card visual on its own, without any other fields added to the Values section?