Forum Discussion
What if parameter don't flows to table
I created a What IF parameter to classify products categories between High Profit and Low Profit.
Everything works, but what doesn't work is that I wanted the margin value to change dinamically, so in the grouping table I included the parameter measure instead of a fix number.
But, it won't change when I select a new parameter in the slicer, it keeps showing the default value (0.15)
What am I missing?
Thanks
@RGL, it's not clear. You can't what-if in a column. It's close to creating a measure and a binning.
Recommended
https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://radacad.com/dynamic-banding-or-grouping-in-power-bi-using-dax-measures-choose-the-size-of-bins
https://www.credera.com/blog/technology-solutions/creating-aging-report-using-a-user-selected-date-in-power-bi/
2 Replies
- amitchandak
Super User
@RGL, it's not clear. You can't what-if in a column. It's close to creating a measure and a binning.
Recommended
https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://radacad.com/dynamic-banding-or-grouping-in-power-bi-using-dax-measures-choose-the-size-of-bins
https://www.credera.com/blog/technology-solutions/creating-aging-report-using-a-user-selected-date-in-power-bi/ - Greg_Deckler
Community Champion
Anonymous - If you are trying to use that measure in a calculated column it is always going to return the default because calculated columns are not dynamic.