Forum Discussion

Sjmiller's avatar
Sjmiller
Regular Visitor
2 years ago

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