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.
Solved! Go to Solution.
Hi , @shanerolle
Take a try to change your measure as below:
Condition =
VAR Percent_ =
[Expense Measure] / SUM ( GLBDWithFYEMO[Budget] )
RETURN
IF (
LEFT ( SELECTEDVALUE ( 'Table'[Account] ) & "", 1 ) <> 5,
SWITCH (
TRUE (),
Percent_ < .9, 1,
Percent_ >= .9
&& Percent_ < 1, 2,
Percent_ >= 1, 3
),
SWITCH (
TRUE (),
Percent_ < .9, 3,
Percent_ >= .9
&& Percent_ < 1, 2,
Percent_ >= 1, 1
)
)
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi , @shanerolle
Take a try to change your measure as below:
Condition =
VAR Percent_ =
[Expense Measure] / SUM ( GLBDWithFYEMO[Budget] )
RETURN
IF (
LEFT ( SELECTEDVALUE ( 'Table'[Account] ) & "", 1 ) <> 5,
SWITCH (
TRUE (),
Percent_ < .9, 1,
Percent_ >= .9
&& Percent_ < 1, 2,
Percent_ >= 1, 3
),
SWITCH (
TRUE (),
Percent_ < .9, 3,
Percent_ >= .9
&& Percent_ < 1, 2,
Percent_ >= 1, 1
)
)
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-easonf-msft ,
Thank you for the assistance! That measure very nearly works, and I believe the only reason it doesn't is because I didn't specify a detail.
When the Account Numbers are stored, they are stored as something along the lines of "000. 0" where there are two spaces between the dot and the final number. This is a way to have two accounts, such as "005. 1" and "005. 2" where they are only slightly difference and a way to tell the difference. The problem is that this must be stored as a text value, and then the part of the measure:
LEFT ( SELECTEDVALUE ( 'Table'[Account] ) & "", 1 ) <> 5,
Does not work because it is comparing to a number instead of text, I tried to change it to "5" but it does not appear to work properly when comparing and only ever uses the else rule in the if/else statement.
Sorry for the confusion, and hopefully this is an easy fix.
Thanks for the help!
Shane
Hi , @shanerolle
Take a try to change the part of measure as below :
LEFT ( SELECTEDVALUE ( 'Table'[Account] ) & "", 3 ) <> "005"
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |