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 everyone,
I am looking to use the hasonevalue and switch true to dynamically present some trend information using a field parameter.
The below is the error and dax I currently have.
Any help would be great.
Error:
Calculation error in measure 'Switch Measures[Test Switch Value BUD Financial]: Column [Parameter Trend] is part of composite key, but not all columns of the composite key are included in the expression or its dependant expression
Dax:
Solved! Go to Solution.
@trwatts , there is challenge when we directly check the value. I have used this code to check the selected value
What is selected = maxx(filter('Axis Slicer', 'Axis Slicer'[Axis Slicer Order]= SELECTEDVALUE('Axis Slicer'[Axis Slicer Order])),'Axis Slicer'[Axis Slicer])
Check if that is blank means , nothing selected
or try hasonevalue on order column
@trwatts , there is challenge when we directly check the value. I have used this code to check the selected value
What is selected = maxx(filter('Axis Slicer', 'Axis Slicer'[Axis Slicer Order]= SELECTEDVALUE('Axis Slicer'[Axis Slicer Order])),'Axis Slicer'[Axis Slicer])
Check if that is blank means , nothing selected
or try hasonevalue on order column
Worked it out.
Thank you for your help it is greatly appreciated. 🙂
Thanks @amitchandak
I have tried the order value in the hasonevalue section and havent had any luck.
Not sure exactly where to drop the formula you gave into the dax?
User | Count |
---|---|
27 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
6 |