Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
How do you calculate a ratio in DAX.
I am formulating a monthly report and want to include a ratio for CV Sent:Interviews in the past month.
CV sent would be a sum and Interviews is a count.
Both of these values have individual consultants attached to them. Ideally I'd like to be able to show a ratio for each consultant.
all help is appreciated, thanks
Solved! Go to Solution.
Hi @Anonymous ,
Incase you want to get the ratio as 1:x .
Create a measure
Ratio 1 = DIVIDE( [Team CV Sent] , [Team Interviews])
Then concatenate
Ratio_Calc = CONCATENATE("1", CONCATENATE(" : ", [Ratio 1]))
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Hi @Anonymous ,
Create a measure as follows:
Ratio Value = [Team CV Sent] / [Team Interviews]
Ratio_Calc = CONCATENATE("1", CONCATENATE(" : ", [Ratio Value]))
Thanks,
Pragati
I had the same issue and this formula worked for me, however, the ratio is not appearing in whole numbers. My result is 1:5.4637..... How can I get the result to show as just 1:5?
Use ROUNDUP with a 0 for the second argument when you're concatenating.
examples:
RATIO = CONCATENATE(ROUNDUP(Table[Measure],0), ":1") -- will display as '#:1'
RATIO = CONCATENATE("1:", ROUNDUP(Table[Measure],0)) --will display as '1:#'
Hi @Anonymous ,
You can achieve this by doing 2 calculations:
Then create a 3rd calculation by concatenating these 2 calculations with a ":" sign.
Share some sample data so that a proper DAX can be suggested.
Thanks,
Pragati
Hi @Pragati11 ,
Thank you for your help
I have written the two measures to put against each other.
What formula do I use to make them a ratio.
Measures written are attached.
Hi @Anonymous ,
You can create another dax as follows:
Ratio_Calc = CONCATENATE([Team Interviews], CONCATENATE(" : ", [Team CV Sent]))
Just see of this works.
Thanks,
Pragati
HI @Pragati11
Thanks for your help again.
The ratio came out as below.
Is there any way to make this ratio a 1:(Number) ratio, as this would be far more useful
Hi @Anonymous ,
Create a measure as follows:
Ratio Value = [Team CV Sent] / [Team Interviews]
Ratio_Calc = CONCATENATE("1", CONCATENATE(" : ", [Ratio Value]))
Thanks,
Pragati
Hi @Anonymous ,
Incase you want to get the ratio as 1:x .
Create a measure
Ratio 1 = DIVIDE( [Team CV Sent] , [Team Interviews])
Then concatenate
Ratio_Calc = CONCATENATE("1", CONCATENATE(" : ", [Ratio 1]))
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |