cancel
Showing results for
Did you mean:

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.

Helper I

## Sum of subsets and their percentage

First of all, thank the community for its invaluable help.

I know what I'm going to ask is stupid, but I've been trying to find the solution for days and I know it's very easy.

Context:
The "material_passport" table has an RLS filter applied to the user_email field, to only show the data of a user, in addition, a filter is usually applied at the report level on the id field to only show the data of a report.

The following relationships exist:
material_passport[id]=product[material_passport_id]
product[id]=material[product_id]
material[family]=material_family_catalog[code]

The material table has a weight indicator called material[intensity]

I need to obtain a new measurement that tells me the % intensity of a material relative to its family.
That is, if a material A weighs 3, a material B weighs 2, the measurement for material A will be "3/5" and for material B it will be "2/5"

I know it's probably easy but taking into account the RLS filter and so on, it has me very confused.

Thanks a lot.

1 ACCEPTED SOLUTION
Helper I

I finally found the solution by myself.
Thank you very much, I close the case.

4 REPLIES 4
Super User
``The "material_passport" table has an RLS filter applied to the user_email field``

Yeah, but it also has a bidirectional relationship.  That negates the RLS.

Get rid of all the bidirectionals if you can.

Helper I

It surprises me because I have tested the report (publishing it via the web in a Power BI embedded capacity) and the RLS works well.

My question is how to calculate the measurements associated with the percentage of the intensities of a material over the total of its family.

Greetings

Community Support

Hi @Frank_Ruiz ,

Could you please provide some sample data in your tables  (exclude sensitive data) with Text format and your expected result with special examples and screenshots. Later I will check if there is any workaround to achieve your requirement. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

Calculate the measurements associated with the percentage of the intensities of a material over the total of its family.

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper I

I finally found the solution by myself.
Thank you very much, I close the case.

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors