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.
Hello, I have a measure which calculates the FTE (Sum of column25 divide by max value of a Column (Column59) :
But, when i replace the FTE measure by the outside_top10 measure : all the summarized values are incorrect (all 0) but the grand total remains correct : 114,38 :
Do you know how to solve this ?
Hi,
Share some data, explain the question and show the expected result.
My column 25 is composed of numbers which can be negative and sometimes cells are blank :
The column23 is a column with client name. Of course, the same client is present in different lines with different values for the column25 (positive, negative, blank). The interesting thing I noticed is that no matters the other column I'm adding with the measure "Outside TOP2", the summarized values are wrong (either it shows 0 for all values either it shows not all values aggregate). With the measure [FTE], everything works fine (summarized values, you can see the sum of values by regional code is 266) but with the other measure, only the grand total is correct
@Eliot4 , Try like
Outside TOP10_2 =
Sumx(values('Database (2)'[Column23]),
calculate(
[FTE] - SUMX(
KEEPFILTERS(
TOPN(10, ALL('Database (2)'[Column23]), [FTE])
),
[FTE]
)))
Sir I think your formule is close to be the right one but the blank cells in Column25 is is setting the sum equal to 0 each time one line with a regional code has a blank cells in Column25 !
The summarized values (i.e FTE outside top 10 by region code) are still incorrect 😣 (all showing 0) but grand total remain correct
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |