The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Sir,
I build parameter with criteria measure to let user can choose what kind of attribute(number) criteria they want then separate the product level as better and best two level.
Visual plus filter works well but when I wanna calculate the how many product are best and how many are better than I got problem. during the debugging, it seems parameter user choose can not dynamic to change the table result, only visual.
is there any method can let me build a new measure to based on user selected result ?
hI @Venson
"While What-If parameters can be used within tables without causing errors, they essentially behave as if no filter is applied. Calculated tables only update when modified or when the underlying data is refreshed, and they do not respond to slicer selections. This behavior extends to using What-If parameters in calculated columns as well. In essence, What-If parameters are intended for use in visuals.