Forum Discussion
ArjanL
8 years agoFrequent Visitor
Three different filtered visuals based on one slicer
Hello, I am new to Power BI and struggling to achieve the following. I have contracts with a starting date and a termination date. SO: ContractA 2015-10-05 2016-07-17 ContractB 2016-04...
praiselyabraham
Resolver II
8 years agoHi ,
Create a date table have relationship between your table and the date table using start date.
Create another inactive relation between date table to your table using the end date.
Create 3 measures, each for the 3 scenario's
Measure1 = VAR X=CALCULATE(count('Table1'[Id]),FILTER(
'Table1',
('Table1'[Start_Date]>= FIRSTDATE('Date'[Date]) &&
'Table1'[End_date] <= LASTDATE('Date'[Date]))))
RETURN IF(ISBLANK(X),0,X)
Measure 2= count([Id])
Measure 3= calculate( count([ID]),userelationship(table1[end_date],date[date]))
Now create 3 visuals, using measure 1 for the criteria 1, measure 2 for the criteria 2, measure 3 for the criteria 3.
Hope this solves your concern.
Regards.