Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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?
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.