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 am attaching my sample file in this file Please see Page 1, i have calculated column named "Count of Reservation" and one measure named "Count". THe bar chart on page 1 is giving me correct result on all time periods but no slicers are working with this. Please help me resolve this issue.
1 | 7/1/2017 | 12/31/2017 | 1 |
2 | 7/1/2018 | 6/30/2019 | 3 |
3 | 7/1/2017 | 9/30/2017 | 1 |
4 | 10/1/2017 | 12/31/2017 | 1 |
5 | 1/1/2018 | 3/31/2018 | 2 |
6 | 4/1/2018 | 6/30/2018 | 2 |
7 | 7/1/2018 | 9/30/2018 | 2 |
8 | 10/1/2018 | 12/31/2018 | 2 |
9 | 1/1/2019 | 3/31/2019 | 3 |
10 | 8/1/2017 | 9/30/2017 | 1 |
Solved! Go to Solution.
Hi @Anonymous
You may create two measures as below:
Measure = COUNTX ( FILTER ( GENERATE ( Dates, Reservation ), Dates[Date] >= Reservation[Fromdate] && Dates[Date] <= Reservation[Todate] ), Reservation[ID] )
Measure 2 = [Measure]/365
Regards,
Cherie
Hi @Anonymous
You may create two measures as below:
Measure = COUNTX ( FILTER ( GENERATE ( Dates, Reservation ), Dates[Date] >= Reservation[Fromdate] && Dates[Date] <= Reservation[Todate] ), Reservation[ID] )
Measure 2 = [Measure]/365
Regards,
Cherie
Thanks alot for your help
Not seeing the PBIX. Perhaps has something to do with your relationships between tables but tough to say.
Please see Page 1 in the file and Count of Reservation calculated column and Count Measure.
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |