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.
Hello,
I have data of what the customer searches on the website I use the page view metric from Google Analytics to achieve this result, however, it is so much that I put a filter on it.
An example. Here I put a filter of greater than 200, this gives me a good view:
The thing is when I filter with a slicer on date I want the filter "greater than 200" to be automatically removed because otherwise I won't see my data.
Example: I look at a specific date and filter greater than 200 is still active so no data:
Is this possible?
Solved! Go to Solution.
Hi @Niels_T ,
You can create a separate calendar table, and an option table.
Table 2 = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))
nValue =
IF (
ISFILTERED ( 'Table 2'[Date] ),
CALCULATE (
MAX ( 'Table'[Value] ),
FILTER (
'Table',
MIN ( 'Table 2'[Date] ) <= [Date]
&& [Date] <= MAX ( 'Table 2'[Date] )
)
),
IF (
ISFILTERED ( 'Table (2)'[Slicer] ),
CALCULATE ( SUM ( 'Table'[Value] ), FILTER ( 'Table', [Value] > 200 ) ),
SUM ( 'Table'[Value] )
)
)
When you don’t use the date slicer, only values greater than 200 are displayed. When you use the date slicer, the filter greater than 200 is ignored.
You can check more details from here.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Niels_T ,
You can create a separate calendar table, and an option table.
Table 2 = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))
nValue =
IF (
ISFILTERED ( 'Table 2'[Date] ),
CALCULATE (
MAX ( 'Table'[Value] ),
FILTER (
'Table',
MIN ( 'Table 2'[Date] ) <= [Date]
&& [Date] <= MAX ( 'Table 2'[Date] )
)
),
IF (
ISFILTERED ( 'Table (2)'[Slicer] ),
CALCULATE ( SUM ( 'Table'[Value] ), FILTER ( 'Table', [Value] > 200 ) ),
SUM ( 'Table'[Value] )
)
)
When you don’t use the date slicer, only values greater than 200 are displayed. When you use the date slicer, the filter greater than 200 is ignored.
You can check more details from here.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Niels_T , This will sum of dates where count > 200
make sure you date do not have timestamp
sumx(filter(Summarize(Table,Table[date],"_1", count(Table[date]])),[_1]>200),[_1])
Date = [Datetime].date
or
Date = date(year([Datetime]),month([Datetime]),day([Datetime]))
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |