Cloud and desktop version showing different results
Hello everyone, I hope I got the right forum... and I also hope someone can help me to understand where the problem lies. On my MySQL database I have one table GoalsTarget with these values: Name|Target milestone Goal 1 | MS01 Goal 2 | MS01 Goal 3 | MS03 Then I have anothe table GoalsForecast with these values: Name|Forecast milestone Goal 1 | MS01 Goal 2 | MS02 Goal 3 | MS05 Then I have a view v_results that gives an overview on which goal will reach the target ("1" is "Yes", "0" is "No", of course) Name|Forecast|Target|Meet Goal 1 | MS01 | MS01 | 1 Goal 2 | MS01 | MS02 | 0 Goal 3 | MS03 | MS05 | 0 If I pull these data on pbi desktop, everything works fine (the "T" is the equivalent of the "Meet" column, i.e. if "Forecast" = "Target"). I then publish it on the cloud, and everything is still fine. When the scheduled refresh kicks in, I have always "0". If I pull the data from the desktop at the same time, the data are still fine. I really don't know where the problem could lie... any suggestion?
Need help quick! Percent On Time measure not working with filters?
I have a whole page dedicated to exploring our products that have shipped late, meaning there is a page filter for [On Time Ship]="False". I also have a measure to calculate the % on time for each product. The formula is: % On Time = CALCULATE(DISTINCTCOUNT(CVD_OTD_FTMS_IV[Reference Number]),CVD_OTD_FTMS_IV[On Time Ship]=true(),REMOVEFILTERS(CVD_OTD_FTMS_IV[On Time Ship]))/CALCULATE(DISTINCTCOUNT(CVD_OTD_FTMS_IV[Reference Number]),REMOVEFILTERS(CVD_OTD_FTMS_IV[On Time Ship])) where [Reference Number] is the unique identifier for someone's ordered item. This measure isn't working the way I want it to and I am not sure why. The count of late items works as expected, but the total count (or denominator in my % on time measure) doesn't show what I expect unless I remove the page filter for [On Time Ship]="False". I don't know why this would be the case since I have a RemoveFilters command in the measure formula?? For example, the product below shows this with the page filter applied: and the same product without the page filter applied: The real total count is 277 for this product. Why is it only 55 when the page filter is applied?? I need help rather quickly, please and thank you!!
Unable to Refresh desktop after updating PBI
Two of my reports won't refresh at all, and a third has a completely blank report, although the data is there in the data tab. My fellow developer has not updated and he has no problems. The reports on the service are refreshing just fine. If I refresh individual tables, they're fine, but when I hit refresh at the top it all fails. I have uninstall and reinstalled Power BI.
DAX Measure to Ignore Date Slicer
Good Day, I have a date slicer with a direct relationship with the table of unique values that I want a measure to ignore regardless of the active date slicer on the same visual page. I used the formula "ALL" to give me the total count of all unique ID in the table ignoring the slicer. Measure=CALCULATE (COUNT (Unique ID[ID), ALL('Calendar'[Date])) But... I want this measure to have a filter for a specific value which i used next as Measure = CALCULATE(COUNT(Unique ID[ID),FILTER(UniqueID,'Unique ID[Attempts ID]=FALSE()),ALL('Calendar'[Date])) Using this formula the date slicer is affecting the measure. Can someone please correct me if the measure i using is wrong.
Preventing Server Report from being opened in Desktop
When you publish a report on the server, there is an option towards the top of the page that allows people with more than just viewer rights to open the report in desktop. Is there a way to publish a report without allowing this to happen? Take away the option to open in desktop. I am not a full admin but I have rights to publish reports in the server and add users, refresh schedule times, etc. Thanks
