Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Try this:
=IIF(Fields!Group.Value = "Yes", Count(Fields!Value.Value), 0) / Count(Fields!Value.Value)
@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.
The expression should be used in a group row but it looks like you used it in a detail row.