Forum Discussion
Sjmiller
2 years agoRegular Visitor
PowerBI vs PowerBI report builder issues
I have a PowerBI data set that I am connecting to in PowerbiReport Builder. But its not pulling over all the rows or something. Here is my situation.
I am trying to count the number of interactions with "Community" for the North and South team. In powerBi I have these calculations done and they are right. But when I do the SAME calculation in PowerBI report builder with that data set it is wrong. For instance,
In PowerBI I do a simple CountRows where "Community " is in the Place of Contact and then also a simple Countrows on all and divide the two to get my %
When I do this calculation =Sum(IIf(Fields!PlaceOfContact.Value = "Community", 1, 0))/COUNT(Fields!CaseNo.Value) which is the same thing my numbers are not the same the report builder is wrong . but it’s the same dataset! I brought over all the fields. It is infuriating. When I tried to use my measure for community and total that does not work either.
No RepliesBe the first to reply