Forum Discussion
Helper I(Blank) in slicer
Please see this article on blank row and limited relationships
"The blank row is created for regular relationships that are invalid – that is, when there is at least one row on the many-side that does not have a matching row on the one-side of the regular relationship"
In directlake or direct query since the data is remote it has to assume a limited relationship. To remove the blank row select the assume referential integrity button when creating the realtionship. If this selected but there isn't RI, you will see differences between sub totals and totals.
Community SupportHi tkiwi,
Thanks for reaching out MS Fabric community support.
Deku thanks for your prompt response. please select below check box to disable blanks.
Thanks,
Prashanth
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query
Helper IThanks but as Deku said, this is not an option (for me) because
" If this selected but there isn't RI, you will see differences between sub totals and totals."
May I ask if you have gotten this issue resolved?
HI tkiwi ,
we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Regards,
B Manikanteswara Reddy