Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hi All,
Is it possible to create Measure Selection with direct query mode ?
I know a way to create with what if parameters but what if parameters are not working for direct query.
@Anonymous
I am able to use that in Direct Query Mode
What if = var _1= ([Parameter Value]) return _1* [Gross Sales]
The parameter value is the default measure created in what if
@amitchandak
I coulnd't understand what you mean
I mean using this parameter for measure selection.
How can i use what you say ?
I'm confused.
| User | Count |
|---|---|
| 22 | |
| 22 | |
| 20 | |
| 19 | |
| 11 |
| User | Count |
|---|---|
| 66 | |
| 56 | |
| 46 | |
| 44 | |
| 31 |