Forum Discussion

ashmitp869's avatar
ashmitp869
Responsive Resident
2 years ago

Help needed for Power Bi Paginated report builder

Hi All, I have Power BI Dataset where I created the relationship between different tables. Now I need to create Paginated Report from it as I report might contains more than one pages details.   ...
Need Help
ashmitp869's avatar
ashmitp869
Responsive Resident
2 years ago

Hi Jianpeng,

 

Thanks for the reply. Will you please help me with the dax query.

Here is my query in Paginated Report.

EVALUATE SUMMARIZECOLUMNS('PayItem'[ProjectId], 'PayItem'[PayItemId], 'PayItem'[PayItemNumber], 'PayItem'[Description], 'PayItem'[UnitOfMeasureName], 'PayItem'[ForecastTakeOffQuantity], 'PayItem'[ForecastUnitRevenue], 'PayItem'[ForecastFinalRevenue], 'Projects'[Project_id], 'Projects'[Project ID], RSCustomDaxFilter(@ProjectsProjectID,EqualToCondition,[Projects].[Project ID],String))

 

I need to Join with 'PayItem'[ProjectId] and 'Projects'[Project_id] . As I did it in my Semantic Model.

I thought it will done by its won but not.

 

I have tried this query:

EVALUATE
SUMMARIZECOLUMNS(
'PayItem'[ProjectId],
'PayItem'[PayItemId],
'PayItem'[PayItemNumber],
'PayItem'[Description],
'PayItem'[UnitOfMeasureName],
'PayItem'[ForecastTakeOffQuantity],
'PayItem'[ForecastUnitRevenue],
'PayItem'[ForecastFinalRevenue],
'Projects'[Project_id],
'Projects'[Project ID],
RSCustomDaxFilter(
@ProjectsProjectID,
EqualToCondition,
[Projects].[Project ID],
String
),
'Projects'[Project_id] = 'PayItem'[ProjectId]
)

as well but giving me this error.

Any help please

ashmitp869's avatar
ashmitp869
Responsive Resident
2 years ago

I am expecting they should be same.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, ashmitp869 

    There is a problem with the following part of your DAX expression:

    Such writing is not supported in DAX. You can check to see how filter is written in my query DAX expression:

     

     

     

    You can edit your query directly in the Query Designer. You can match the two tables as shown above.

     

     

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.