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 created A new table the name is FuTable .
The futable has two colums
"FU" contais product name and it is unique
"MesaureDif" contais SUM(FuForecast[sales])-SUM(FUforecast[forecast]) . it feeds from FuSales table and it has FU colum also
FUTable
FU | MeasureDif |
A | 10 |
B | 9 |
C | 8 |
D | 7 |
E | 6 |
F | 5 |
G | 4 |
H | 3 |
K | 2 |
L | 1 |
I added A Measure and determinate Top 4 materilal
Top 4 = RANKX( All(FUTable);FUTable[MeasureDIF])
When I add A new mesause it doesnt work
for example
Measure = If(FUTable[TOP10]>4;"Others";FUTable[FU])
it is not accept FU table[FU]
When I add a new colum . This time Formule is not write "others " for smaller value from 4
I just want write "others" for the product top4 value less then 4
Solved! Go to Solution.
Hi All,
I think I solve the issue
Icreate FU table for all calculated table "dis2,dis4 ,cum2,cum4" then it worked .
Thank you all for your ideas and solutions
Best regards
Sinan
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 |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |