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 Report Builder. My measure in Power BI is:

 

% Yes = 

VAR _yes = CALCULATE(COUNT('Table'[Value]), FILTER('Table', [Group] = "Yes"))
VAR _total = COUNT('Table'[Value])
RETURN
DIVIDE(_yes, _total)

 

Any help is greatly appreciated, thank you in advance!

Power BI report builder

3 Replies

  • 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.