Forum Discussion

NJ81858's avatar
NJ81858
Icon for Helper IV rankHelper IV
3 years ago

Measure in Power BI Report Builder

Hello,   I am transferring a report from Power BI to a paginated report and I have a measure in my Power BI report that I am not sure how to transfer it over to the paginated report in Power BI Rep...
Power BI report builder
Shahfaisal's avatar
Shahfaisal
Icon for Solution Sage rankSolution Sage
3 years ago

Try this:

 

=IIF(Fields!Group.Value = "Yes", Count(Fields!Value.Value), 0) / Count(Fields!Value.Value)

  • NJ81858's avatar
    NJ81858
    Icon for Helper IV rankHelper IV
    3 years ago

    Shahfaisal I have entered this as a formula but when I try and input that into my graph, it gives me the following error:

     

    "The expression used for the calculated field 'Percent' includes an aggregate, RowNumber, RunningValue, Previous or lookup function. Aggregate, RowNumber, RunningValue, Previous and lookup functions cannot be used in calculated field expressions.
    ----------------------------
    The definition of the report '' is invalid.
    ----------------------------
    An error occurred during local report processing."

     

    I am not sure where I am going wrong with my formula.