Forum Discussion

ahmadibrahimbus's avatar
ahmadibrahimbus
Resolver III
3 years ago
Solved

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,