User Profile
Giu
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Drill Throught problem on measures previous years
HI All, I have this report with on the top a date filter blocked on this Year with a slicer. Then I have this table : FULL 2022 FULL 2023 YTD 2023 YTD 2024 Product A 100 120 80 85 Product B 110 130 100 95 With those dax measures: FULL 20222= CALCULATE(sum([Revenues]),DATESBETWEEN ( Calendar_DAX[Date], DATE(2022, 1, 1), DATE(2022, 12, 31))) FULL 20223= CALCULATE(sum([Revenues]),DATESBETWEEN ( Calendar_DAX[Date], DATE(2023, 1, 1), DATE(2023, 12, 31))) YTD 2023= CALCULATE(SUM(Revenues),SAMEPERIODLASTYEAR(Calendar_DAX[Date])) YTD 2024= SUM(Revenues) (there is the filter on the current year on the top) Now Drill Throught works correcty for 2024, but not for other periods. Could you suggest me a solution, please? Thanks in advance GiuseppeDIvide in a table in a row
HI All, I have a table in PBI like this - TYPE is a dimension in another table related to the main table - Gross Margin is the total - Amount is a measure into the main table - LY is a DAX field formula calculate as sum of Amount SAMEPERIODLASTYEAR(Calendar_DAX[Date]) I want to add another row with % divide cost\revenues like this Any idea wich is the simpliest solution,please? ThanksModelling double fact tables -Star schema
HI all, I have a question about the schema below . I want to create a report starting and filtering from one or more "agreements" I'd like to include into the same report a matrix with events for type for each person included in the selected agreements. Relations: - agreements - person many to many - person - events many to many - No relations agreements - events Constraints: - No double filter direction - No Dax code Any idea how to do it ? Thanks Giuseppe
