Not Showing Post Publish

[KeatonO]

Hello all, I have a weird one that has me a little stumped. It's a pretty simple formula and that is why I am so confused about why this is happening. I am counting the number of times each agent is using certain dispositions. I have a Microsoft power apps that the agents place a code, that code gets dumped into a SharePoint table and is then accessed by my power bi to count use. 

Here is the table 

It's line-by-line boolean logic for true or false. 

My formula for counting is as follows. 

Total 3 Month Hold = calculate(counta('Supplies PIM'[3 Month Hold?]), 'Supplies PIM'[3 Month Hold?] = "True")

Then I have date slicers for timing. 

on desktop, it is correct and looks like this. 

When I publish to our company app, it looks like this...

There are no changes to the source data, permissions, filters, everything else in the report works just fine but when published, I run into this error.

Any ideas on what I am doing wrong or how to correct it? 

[v-yiruan-msft]

Hi @KeatonO ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily when they face the similar problem with you. Thank you.

Best Regards

[v-yiruan-msft]

Hi @KeatonO ，

What data type is the column "Hold for 6 Months?"? Whether it was set as Any? If yes, the values of this column can differ between the Power BI Desktop and the Power BI service after a refresh. In Power BI Desktop, the underlying engine converts the boolean values to strings, retaining TRUE or FALSE values. In the Power BI service, the underlying engine converts the values to objects, and subsequently converts the values to -1 or 0. That's the cause why you got the different result in the Power BI Desktop and the Power BI service... Please review the content in the following links for the details.

Refresh a column of the ANY type containing TRUE/FALSE results in unexpected values

Reports doesn’t show data in Power BI Web service after refresh – Issue with True/False values

Please try to update the formula of your measure as below or update the data type of the column "Hold for 6 Months?" as Text:

Total 3 Month Hold =
CALCULATE (
    COUNTA ( 'Supplies PIM'[3 Month Hold?] ),
    FILTER (
        'Supplies PIM',
        'Supplies PIM'[3 Month Hold?] = -1
            || 'Supplies PIM'[3 Month Hold?] = "True"
    )
)

Best Regards

[AllisonKennedy]

@KeatonO  This is a strange one - have you published this report previously? Try changing the name and see if it still gives the same problem, or delete the dataset from Power BI service and republish. If you overwrite a dataset it sometimes can't make all changes unless you delete/start fresh. 

[KeatonO]

Kind of a pain in the butt to do but it worked! thank you!

[AllisonKennedy]

You're welcome! Glad it worked. 

[KeatonO]

Hello there, I marked the prior comment as a solution. However, today (after the auto-refresh) it has seemingly reverted to having the same issue again. I would need to manually refresh on the desktop and publish daily to get this to work. I, unfortunately, need to find a solution to this long term. 

[KeatonO]

Nope, it's actually reverted back to the same issue as before. Desktop, it will refresh fine, once published it will error out and show blank on the counts.