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 there,
I am rewriting my message with current status.
I have a working messure as below:
Not Working % =
VAR _Ratio =
DIVIDE (
SUM ( 'Table'[Col. 2 ) + SUM ( 'Table'[Col 3] ), (1)
)
RETURN
MIN ( _Ratio, 1 )
OUTCOME
All values of product are dispalying as 100%.
Help will be appreciated.
Hi @sdhn ,
I have the same doubt as @AlexisOlson : Why do you divide by 1 in the "Not Working" measure?
Not Working % =
VAR _Ratio =
DIVIDE (
SUM ( 'Table'[Col. 2 ) + SUM ( 'Table'[Col 3] ), (1)
)
RETURN
MIN ( _Ratio, 1 )
What do the two columns represent? What is your calculation logic?
Best Regards,
Icey
without DIVIDE option
Not Working % =
VAR _Ratio =
(
SUM ( 'Table'[Col. 2 ) + SUM ( 'Table'[Col 3] ), (1)
)
RETURN
MIN ( _Ratio, 1 )
OUTCOME
ALL Products is displaying as 100 %
without RATIO,
Not Working % = SUM ( 'Table'[Col. 2 ) + SUM ( 'Table'[Col 3] ), (1)
OUTCOME:
getting very large values
Below
I don't follow what the ratio is intended to be in the second example. Why are you dividing by 1?
I do not have an answer. Just trying to copy working code. (First one)
Any product over 100 % must shows as 100 %. Also 100 must display as 100 too.
Rest same as they are. Thanks
It's not easy to answer a question based on what you don't want. What result do you want?
Why are the results you're getting not correct? How do you know they're not correct if you don't know what they should be? What do you expect to get if things work properly?
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 |
---|---|
44 | |
26 | |
22 | |
11 | |
8 |
User | Count |
---|---|
75 | |
50 | |
47 | |
17 | |
17 |