Percentage based on Field Parameter in Matrix

[Anonymous]

Hello everyone,

Sorry if there is some information is lacking but this is actually my first time posting in here!

I am having a bad time writing a measure to calculate the % based on Field Parameters and I was wondering if someone has already done something similar successfully.

I have created a sample data and I will be using it in the following examples, the file I am currently using for these tests can be downloaded from here: https://drive.google.com/file/d/1qUChGKX3KiUA6XFuYbphpeYyoYPgBFZn/view?usp=drivesdk.

My visual currently looks like this:

The matrix visual is designed like this:
Rows: Country, Parameter

Columns: Year

Values: ID (count), Measure

-------

Measure: 

0_MEASURE =

DIVIDE (

CALCULATE (

COUNT(TB1[ID])

),

CALCULATE ( COUNT(TB1[ID]), ALLSELECTED ( ), GROUPBY(TB1, TB1[Year])

))

------

The Field parameter uses the following columns: Battery, Bluetooth, Color, Shape, Type and Wi-fi.

The slicer also has the Field Parameter values included so I can filter which Field I want to see in the matrix, in the order I selected them.

In this case I have filtered first "Wi-fi" and then "Color". The expected result in this case would be Blue with 50% and Red with 50% as well since there are only 2 values and 100% in the with Wi-fi right above since there is no without (instead of 66,67%). Basically I would like the % to be calculated based on the current level of the Field Parameter. I tried using INSCOPE but I had no success and also for having more than 400 values in Field parameter it would be a problem to add all of the columns in the measure. Does anyone know if it would be possible to dinamically calculate it?

Sample data:

ID	Year	Description	Color	Shape	Battery	Bluetooth	Wi-fi	Type	Country
1	2021	Description 1	Red	Square	with	without	with	T1	US
2	2019	Description 2	Red	Circle	without	without	with	T1	Germany
3	2023	Description 3	Blue	Circle	with	with	without	T3	Germany
4	2020	Description 4	Purple	Triangle	with	with	with	T2	Spain
5	2020	Description 5	Red	Square	with	without	with	T1	US
6	2019	Description 6	Blue	Triangle	without	with	without	T1	Spain
7	2019	Description 7	Blue	Square	without	without	without	T2	Germany
8	2023	Description 8	Purple	Square	without	with	with	T2	Spain
9	2021	Description 9	Red	Triangle	with	with	with	T3	US
10	2020	Description 10	Blue	Circle	without	with	with	T2	US