topic Re: Update table using slicers in DAX Commands and Tips

Update table using slicers

alavanka — Thu, 27 Oct 2022 10:00:20 GMT

Hello all!

is it possible to change values in a table using slicers?

For example I have a table in my report that I created manually and represents the weight of each feature in my calculation and the total represents 100%:

What I would like to know if it's possible to manipulate the weight of each Feature by changing the percentage using a slicer or something and at the same time guaranteeing that the total doesn't exceed 1 or 100%.

best regards!!

Re: Update table using slicers

tamerj1 — Thu, 27 Oct 2022 10:31:06 GMT

Hi alavanka
Would you please provide an example?

Re: Update table using slicers

alavanka — Thu, 27 Oct 2022 10:40:23 GMT

Not sure how to provide an example...

Imagine having a report where I could use some kind of a numeric range slicer to change weight of Feature 1 from 0,03 to 0,2.

But in other hand having some kind of way to prevent of exceed the total of 1 (sum of all the percentages).

Re: Update table using slicers

tamerj1 — Thu, 27 Oct 2022 11:01:41 GMT

alavanka
I don't want to say this is not possible rather I would say I don't know.

Re: Update table using slicers

FreemanZ — Fri, 28 Oct 2022 05:57:36 GMT

If you mean Query in Power Query, no;

If you mean native or calculated table in Power BI, no;

But if you mean Table Visual in Power BI, yes, as long as the field you use in the slicer is relevant to the fields in the Table Visual.

Re: Update table using slicers

DimaMD — Fri, 28 Oct 2022 06:51:44 GMT

Hi alavanka Try creating a Numeric parameter.

Next, you can write a simple measure

= SUM('Table'[Percentage])+[Значення "Параметр"]

I hope I understood your problem correctly

Re: Update table using slicers

alavanka — Fri, 28 Oct 2022 11:23:13 GMT

Hello DimaMD ,

thank for your reply!

it seems the solution (if possible) its close to the one you suggested. However the Mipa measure changes the values in every row and not in one specific row (I need to have one fixed slice per Feature).

I tried to adjust the measure to just change the sum of Feature 1 but the behaviour is strange... it only changes feature 1 but it doesn't sum up the values like I was expecting...

Maybe the solution is very simple but I am not able to solve it... my knowledge is very limited. 😞

Re: Update table using slicers

DimaMD — Fri, 28 Oct 2022 12:08:18 GMT

alavanka If you want to see the total, then you need the next measure

Міра 2 = IF( HASONEVALUE('Table'[Feature]), [Міра], SUMX( VALUES('Table'[Feature]), [Міра]))

Re: Update table using slicers

alavanka — Fri, 28 Oct 2022 11:42:17 GMT

Sorry. I was not clear. I need an independent slicer for each feature / row.

I just tried for Feature 1 (1st row) assuming that I could replicate the same for the others.

Re: Update table using slicers

DimaMD — Fri, 28 Oct 2022 11:58:58 GMT

alavanka Look at this file, I fixed the parameter and wrote the measure. Please review

Re: Update table using slicers

alavanka — Fri, 28 Oct 2022 12:09:24 GMT

I think that is it. 🙂 Just wondering if I want to replicate to feature 2 together with Feature 1 in Mipa measure what shall I do?

Re: Update table using slicers

DimaMD — Fri, 28 Oct 2022 12:26:25 GMT

alavanka if I understand you correctly, then you need 6 parameters that you will set,

Re: Update table using slicers

alavanka — Fri, 28 Oct 2022 12:59:32 GMT

That is it! Perfect! I would take 100 years to get it by myself... 🙂 Thanks and keep the good work!