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 guess you are just trying to have in a card visual the count of the days that have scores less than 0.8?
if this is the case please try
Low Score =
SUMX (
DISTINCTCOUNT ( 'Table'[Date] ),
IF ( CALCULATE ( SUM ( 'Table'[Score] ) ) < 0.8, 1 )
)
Hi @tamerj1,
this is the error I get when I use your formula: The SUMX function expects a table expression for argument '1', but a string or numeric expression was used.
@kmartink
Apologies, my mistake
Low Score =
SUMX (
DISTINCT ( 'Table'[Date] ),
IF ( CALCULATE ( SUM ( 'Table'[Score] ) ) < 0.8, 1 )
)
Hi @kmartink
make sure you have created a measure not a calculated column by mistake
Hi @tamerj1,
yes what I've created is a measure. I was wondering if the problem might be caused either by that the formula accidentally summarizes all the rows of the "Score" column which would mean the result would be always higher than 80% and so the zero will be displayed? Or either that my "Score" has the Data type "decimal number" and the format "percentage" but the formula uses "0.8" for 80%?
Is there any other way how to rewrite the formula so it might not be accidentally summing up all the rows of the column "Score" if that's the case what's happening right now? I already tried to use "AVERAGE" instead of "SUM" but there wasn't any difference. Thanks.
@kmartink
Would you please present sample fo the data and perhaps a screenshot of the visual?
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |