User Profile
hyugo_v
Helper I
Joined 7 years ago
User Widgets
Contributions
Re: Cumulative sum not working correctly
I found the solution to my problem, i took the wrong parameter in the ALL fonction. Here is the correct one : Cumulative = CALCULATE( SUM('6_RIE_couloir'[Sum E1+E2]), FILTER(ALL('6_RIE_couloir'[Heure]),'6_RIE_couloir'[Heure]<=MAX('6_RIE_couloir'[Heure]) )) Regards,Re: Cumulative sum not working correctly
Hello, i forgot to put some context, the dataset in recording the flux of people through the day, generally people tend to come at 11/11:30 AM so the E1+E2 column have bigger value at that moment, if i filter between 00:00:00 and 01:00:00 that's what i get. Edit : If i remove the Date filter, the chronology is broken.Cumulative sum not working correctly
Hello everyone, i'm trying to get a cumulative sum here but it looks like it doesn't consider the parameters i put in the dax formula. I've tried the same formula in a dataset i made up myself and it worked properly. The table name is : '6_RIE_couloir' What i want to sum is : '6_RIE_couloir'[Sum E1+E2] And minute by minute : '6_RIE_couloir'[Heure] Here is a screenshot for a better explanation : (i've got 0 value at the begging in the column "sum E1 +E2" but there are plenty after that Any ideas ? Regards,Edit only report but not dataset
Hello everyone, I'm struggling about a requirement from my client. An end user should be able to modify the existing report (about the form) on PowerBI service but SHOULDN'T be able to modify the dataset. I checked the "Contributor" role but it allows the user to access and modify the dataset. Having any ideas ? Regards,Re: Edit access to reports but not to dataset
Hello Anonymous, I was told to give the same requirement as the one you mentionned. An end user needs to modify the existing report on PowerBI service but SHOULDN'T be able to modify the dataset. Did it work for you ? Because "Contributor" allows the user to access and modify the dataset. Regards,
