The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
10 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
22 | |
14 | |
14 | |
9 | |
7 |