User Profile
BIlix
Helper II
Joined 3 years ago
User Widgets
Contributions
Need help with a measure calculation
Hello Community, I have a measure that sums a column in a fact table. The fact table has a datekey in Format 20240529 and a Datekeyperiod which is 20240501. Both are integers. Datekeyperiod is related to my Datetable. The datekey stores the date on which the entry was submitted to the facttable I need to calculate my Measure for a Linechart with Year and Month in X Axis and the Measure in Y Axis. The requirement for e.g. January 2024 is that I calculate all Values in my fact table Where Datekeyperiod is in 2024, eg. >= 20240101 and <= 20241201 AND datekey is <= 20243101 and so on. The result should be all values for the current business year in context where the submission entry was in or before the current month in context. Therefore the value for February should be the value for january + rows that were submitted on or before february 29th 2024. VAR Currentyear = MAX(dim_date[year]) VAR CurrentDatekey = MAX(dim_date[datekey]) VAR MaxDate = MAXX(FILTER(ALL(dim_date), dim_date[year] = Currentyear), dim_date[datekey]) VAR MinDate= MINX(FILTER(ALL(dim_date), dim_date[year] = Currentyear), dim_date[datekey]) VAR Filteredtable = FILTER(ALL(facttable), (facttable[datekeyperiod] <= MaxDate && facttable[datekeyperiod] >=MinDate) && facttable[datekey] <= CurrentDatekey ) VAR Result = CALCULATE([Measure], Filteredtable) RETURN ResultRe: Tricky requirement for a slicer filtering
Thanks for your reply. I attached a sample file: https://file.io/sxn8Vw5Cxo8B The outcome should be like this: I tried using Calculation Groups and Field Parameters so far. I also tried to use two overlapping Linecharts to achieve the highlighting of the selected Manufacturer, which is working good, but not perfect. Turn of the Slicer interaction on one line Chart, put it in Background and turn on Slicer interactions on the Line Chart in the front.Power BI App for Sharing to external Users
Hello, I created a report which includes a table with Email of external Customers which should be able to view the report inside a App. Inside PBI Desktop the RLS works, A user can only view its associated data. When I grant Access to the users inside my app, they still get the error, that the report cant be viewed because the underlying report uses rls. Do I have to give every User a permission for the dataset? I thought giving them access for the app should be enough.
