Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi everybody
I'm a beginner in DAX and I would need your help for a fomula... My goal is to calculate the MODE trough the dataset bellow.
I need for each 'EAN description' the MODE value for 'PVM Magasin' and I would need it in a new column to the right.
The formula alse needs to take into consideration the filters selected.
Thanx a lot for your help !
You need a column for the mode per row? Meaning for each row, you're looking for the number that occurs most often in the PVM Magasin column? For example your top row 3 rows would return 9
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 7 | |
| 6 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 17 | |
| 9 | |
| 8 | |
| 7 |