Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, i have a table that i created that shows the volume of something and some percentages
ultimately i am using a date filter to select the time period over a 13 month period to filter all of the data in the table.
i then apply a Month filter (separate column within the data) to get the table to show data for only that month (this year and last year).
I am trying to calculate the 13 month total of volume, however, as i have selected the Month filter whenever i use this calculation it is incorrect on the basis that it only returns the value on the Month that i have selected.
i want the measure to Sum the total volume over that 13 month period i selected via the date slicer, but ignore the Month slicer
and i have treid various versions of this:
Solved! Go to Solution.
Hi @ballist1x ,
One sample for your reference, please check the following steps as below.
1. To create a date table and create inactive relationship between the fact table as below.
date = CALENDARAUTO()
2. To create a measure as below to work the excepted result out.
sumif = IF ( ISFILTERED ( 'date'[date] ), CALCULATE ( SUM ( 'Table'[sale] ), FILTER ( ALL ( 'Table' ), 'Table'[date] IN VALUES ( 'date'[Date] ) ) ), CALCULATE ( SUM ( 'Table'[sale] ), USERELATIONSHIP ( 'date'[Date], 'Table'[date] ) ) )
Hi @ballist1x ,
One sample for your reference, please check the following steps as below.
1. To create a date table and create inactive relationship between the fact table as below.
date = CALENDARAUTO()
2. To create a measure as below to work the excepted result out.
sumif = IF ( ISFILTERED ( 'date'[date] ), CALCULATE ( SUM ( 'Table'[sale] ), FILTER ( ALL ( 'Table' ), 'Table'[date] IN VALUES ( 'date'[Date] ) ) ), CALCULATE ( SUM ( 'Table'[sale] ), USERELATIONSHIP ( 'date'[Date], 'Table'[date] ) ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |