topic Re: Measure in Power BI Report Builder in Report Server

Measure in Power BI Report Builder

NJ81858 — Fri, 16 Jun 2023 17:43:51 GMT

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!

Re: Measure in Power BI Report Builder

Shahfaisal — Sun, 18 Jun 2023 22:35:58 GMT

Try this:

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

Re: Measure in Power BI Report Builder

NJ81858 — Tue, 20 Jun 2023 12:02:13 GMT

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.

Re: Measure in Power BI Report Builder

Shahfaisal — Wed, 28 Jun 2023 02:15:13 GMT

The expression should be used in a group row but it looks like you used it in a detail row.

See https://learn.microsoft.com/en-us/sql/reporting-services/lesson-6-adding-grouping-and-totals-reporting-services?view=sql-server-ver16