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.
I would like to create a percentage from 2 count card visuals.
Visual 1=
Oppertunities that are created in 2018
Visual 2=
Oppertunities that are modified to won in 2018
I made a sample of the data:
Created on | Outlet | Modified By | Status |
12-8-2016 | A | 13-2-2017 | won |
21-3-2017 | B | 12-1-2018 | open |
6-7-2017 | C | 31-1-2018 | won |
12-12-2017 | D | 21-8-2017 | open |
13-1-2018 | E | 13-1-2018 | won |
21-1-2018 | F | 21-1-2018 | open |
1-2-2018 | G | 1-2-2018 | open |
15-2-2018 | H | 1-3-2018 | won |
24-2-2018 | I | 24-2-2018 | open |
4-3-2018 | J | 4-3-2018 | open |
And Visual 2 would display: 3
In this case Visual 1 would display: 6
I want to create a visual that shows the percentage of won oppertunities compared to created oppertunities.
So in this case it would be 50%
The visuals are about the current year and I want them to change automatically in 2019
The problem I encounter is that the relationship with my calender table is with 'Created on', However visual 2 works with 'Modified by'
I tried te following formula:
CALCULATE(COUNT('Table 1'[Outlet]);'Table 1'[Status]="Won";'Table 1'[Modified by]=YEAR(TODAY())) / CALCULATE(COUNT('Table 1'[Outlet]);'Table 1'[Created on]=YEAR(TODAY()))
However this turns out (BLANK)
I hope someone can help me with this!
Regards,
Guido
Solved! Go to Solution.
@Anonymous,
Change your DAX to the following:
Measure = CALCULATE(COUNT('Table 1'[Outlet]);'Table 1'[Status]="Won";YEAR('Table 1'[Modified by])=YEAR(TODAY()))/CALCULATE(COUNT('Table 1'[Outlet]);YEAR('Table 1'[Created on])=YEAR(TODAY()))
Regards,
Lydia
@Anonymous,
Change your DAX to the following:
Measure = CALCULATE(COUNT('Table 1'[Outlet]);'Table 1'[Status]="Won";YEAR('Table 1'[Modified by])=YEAR(TODAY()))/CALCULATE(COUNT('Table 1'[Outlet]);YEAR('Table 1'[Created on])=YEAR(TODAY()))
Regards,
Lydia
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |