Forum Discussion
USE PARAMETER VALUE FOR A COLUMN VARIABLE
Good evening, I have the following variable to create a new column in which according to the ranking number determined by the value of the Total field per family it is determined, according to the var Quantity, if said family is in the Top or in Altres. This variable works correctly but I would like to change dynamically the value 5 of the variable quantity that is now fixed by using a parameter or something similar. Not being a measure I can't get it to take the value dynamically:
Hi Xavier2609 ,
What you are creating is a calculated column, and that what-if parameter was used in this new created calculated column? If yes, as the value of a calculated column is computed during data refresh and uses the current row as a context, it will not change according to the user interaction(slicer, filter, column selections etc.) in the report. So it will not return your expected result, when switch the value of what-if parameter in the calculated column... If you want to get the TOPN and others items dynamically, you can refer the following links to get it by creating measure +what-if parameter or TOPN filter function.
Filter top 3 products with a row for others using DAX in Power BI
DAX Fridays! #132: Dynamic TopN + Others in Power BI
In addition, you can review the following links about the difference of calculated column and measure...
Calculated Columns and Measures in DAX
Calculated Columns vs Measures
There is a big difference between calculated columns and measures. The value of a calculated column is computed during data refresh and uses the current row as a context; it does not depend on user interaction in the report. A measure operates on aggregations of data defined by the current context, which depends on the filter applied in the report – such as slicer, rows, and columns selection in a pivot table, or axes and filters applied to a chart.
Best Regards
8 Replies
Hi Xavier2609 ,
In this case you need to create a what if parameter and then use the metric that is created automatically to change by the quantity part of the measure.
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
Hello MFelix, thank you very much for your reply. In the Calculated Column, the call to the parameter value still does not work:
SELECTEDVALUE ( Parameter[Parameter] )
the problem could be, as I have read, that the functions used internally by HASONEVALUE are incompatible to create table columns with parameter fields.
If it were a measure it would work.
Thank you very much for your time.
Greetings,
Hi,
What type of parameter are you using?
Good evening, thank you for your interest and time.
I use a numerical range created from a new Parameter.
Then in the calculated column, in the variable I try to call the value with the expression:
SELECTEDVALUE ( Parameter[Parameter] )
But it does not take the courage to make the subsequent comparison:
where numeroranking = RANKX(ALLSELECTED('TABLE 11 SUMMARISED without week'),'TABLE 11 SUMMARISED without week'[TOTAL BY FAMILY],,DESC,Dense)where quantity= SELECTEDVALUE ( Parameter[Parameter] )returnif(numeroranking<=quantity,"top","others")If a number is entered instead of SELECTEDVALUE (Parameter[Parameter]), the calculated column works correctly.
A very cordial greeting,
Xavi.
