topic Re: Using what-if parameter at row-level in DAX Commands and Tips

Using what-if parameter at row-level

Anonymous — Thu, 10 Dec 2020 07:27:37 GMT

Hi,

I am fairly new to Power-BI (previous Tableau and Qlik user), I wanted to do something that I thought was basic but I can't figure it out.

-I have a table with in which each row has an integer (let's say sales value). I want to categorize each line based on a parameter value, to define if they are over or under this value.

I created a column comparing the parameter but its content does not change when the parameter value is changed (I read that column are not recalculated during runtime). How can I make it work and have dynamic column but at row level (not aggregated measure) as I need this as a dimension in chart and to filter my data.

I made a dummy example below to synthetize my issue, any help would be appreciated !

Re: Using what-if parameter at row-level

Stachu — Mon, 14 Dec 2020 22:38:55 GMT

Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).

Column1	Column2
A	1
B	2.5

For this to be dynamic you will need to use a measure, iterator functions can calculate per row before aggregation, so it should be achievable - I should be able to give an example if you share your model

Re: Using what-if parameter at row-level

Anonymous — Tue, 15 Dec 2020 08:55:25 GMT

Hi, sure, my actual use case can be sumed up with this sample data, then I can extrapolate :

Order;value

Order1;23

Order2;45

Order3;12

Order4;34

(sorry, the forum does not let me use tables for some reason, I get an "invalid HTML" error)

I also created a simple measure:

Orders = count('Table'[Order])
And a parameter :
Anomaly threeshold = GENERATESERIES(0, 50, 1)

I managed to do this in a table by using a measure :
Profitable order? = SELECTEDVALUE('Table'[Sales value])>'Anomaly threeshold'[Anomaly threeshold Value]

But I would also be able to uses this as a column for these use cases

-Use as a filter (ex: show a table with only the orders below/above this dynamically set value)

-Use as a color legend in a pie or bar chart with the repartition of my orders (below or above this value)

But I am not sure this is doable.