Forum Discussion
Power Bi Builder
could anyone please help.
Im working on power BI paginated report, to create cascading parametrs using dax code for datasets.
the problem with the below dataset dax code that it shows the blank value on power BI and dax studio level ,but it dosen't show it in power bi Builder.
// DAX Query
DEFINE
VAR __DS0FilterTable =
FILTER (
VALUES ( 'Projects'[project_id] ),
PATHCONTAINS ( @ProjectID, 'Projects'[project_id] )
)
VAR __DS0FilterTable2 =
TREATAS ( { "Focus" }, 'Project_Dates'[Dates Slicer] )
VAR __DS0FilterTable3 =
FILTER (
VALUES ( 'EWP Overall'[Area from EWP] ),
PATHCONTAINS ( area, 'EWP Overall'[Area from EWP] )
)
VAR __DS0Core =
SELECTCOLUMNS (
SUMMARIZECOLUMNS (
'EWP Overall'[CWA],
__DS0FilterTable,
__DS0FilterTable2,
__DS0FilterTable3
),
"'EWP Overall'[CWA]", 'EWP Overall'[CWA]
)
VAR __DS0PrimaryWindowed =
TOPN ( 501, __DS0Core, 'EWP Overall'[CWA], 1 )
EVALUATE
__DS0PrimaryWindowed
ORDER BY 'EWP Overall'[CWA]
however in power bi builder it's not show at all and it affect the main datasets by eliminating some results.
could someone please help,it's really wierd.
Best Regards,
I was able to solve it using the below thread:
Solved: Paginated Report Multivalue Parameter and DAX to i... - Microsoft Power BI Community
Thank you prathyoo .
1 Reply
- ahmadibrahimbusResolver III
I was able to solve it using the below thread:
Solved: Paginated Report Multivalue Parameter and DAX to i... - Microsoft Power BI Community
Thank you prathyoo .