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 ?
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 =
[FTE] - SUMX(
TOPN(10, ALL('Database (2)'[Column23]), [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
Check out the changes to the Power BI Community announced at Build.
Find out more about the May 2023 update.
Visit our Data Stories Gallery and give kudos to your favorite Data Stories.