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
Hello
In our project, the objective is to combine two facts of different granularity.
One fact has the lowest level at 'type vergoeding' while the other one has the person as lowest level
(A person has multiple 'type vergoeding')
Logically i get the outcome above.
But i want to have the outcome below.
Is this possible? The FE column should calculate the FE measure, for the rows where 'type vergoeding' = WEDDE
If it can be solved, table or matrix is both okay. But FE is not the only measure that has to react this way.
I wanted to apply the logic that works for FE for the other values
In a matrix you can disable stepped layout and switch off row totals to achieve your desired layout.
Does it have to be a table visual or can it be a matrix?
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 6 | |
| 6 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 21 | |
| 10 | |
| 7 | |
| 7 |