Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello All,
I have added ALL as a row value to one of my parameter in paginated report with below DAX.
EVALUATE
UNION
(
DISTINCT(SELECTCOLUMNS(Projects, "Top_ProjectManager","ALL"))
,
SUMMARIZECOLUMNS(
Projects[Top_ProjectManager],
KEEPFILTERS( FILTER( ALL( Projects[Top_ProjectManager] ), NOT( ISBLANK( Projects[Top_ProjectManager] ))))
)
)
In my master dataset now I need to make the query work as
The master dataset query i have written as below
FILTER(VALUES(Projects[Top_ProjectManager]), OR(Projects[Top_ProjectManager] = @ProjectManager, @ProjectManager = "ALL"))
But in dataset properties Parameters query what should i mention i am unable to understand it.
Can anyone please help me wih this.
Thanks,
Mohan V.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 7 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |