Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello everyone.
I al using a mesure below to get a table with just negatives values and then i get a sum of these values ( the number of values is dynamic as i use a what if parametre). However in my table u see that i get a good total but i want to know how to filter my table so if i choose 3 in the parametre i could get only three values in my table and not ALL values.
I created a rank column in my BASE table (
So i can reference this column in my measure
But it still doesnt work
Thanks a lot
Solved! Go to Solution.
try this code:
Measure =
SUMX (
FILTER (
BASE;
BASE[ MARGE ACT] <= 0
&& BASE[Rank] <= SELECTEDVALUE ( 'Paramètre'[Valeur Paramètre] )
);
BASE[ MARGE ACT]
)
this measure will only show values for whatever is in the top, but you will still see all rows because e.g. 'Paramètre' has value for all entries, not just the Top entries
try this code:
Measure =
SUMX (
FILTER (
BASE;
BASE[ MARGE ACT] <= 0
&& BASE[Rank] <= SELECTEDVALUE ( 'Paramètre'[Valeur Paramètre] )
);
BASE[ MARGE ACT]
)
this measure will only show values for whatever is in the top, but you will still see all rows because e.g. 'Paramètre' has value for all entries, not just the Top entries
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
21 | |
17 | |
16 | |
11 | |
7 |
User | Count |
---|---|
26 | |
25 | |
12 | |
12 | |
12 |