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.
Hellow
CustomerID ContractID Start Location
822TR2020 | CB1_6532020 | 30/10/2020 | 1 |
944TR2021 | CB1_7962021 | 10/04/2021 | 1 |
49TR2020 | CB1_5782020 | 1/03/2019 | 1 |
771TR2020 | CB1_5792020 | 11/12/2017 | 1 |
51TR2020 | CB1_202020 | 22/04/2019 | 1 |
898TR2021 | CB1_7432021 | 2/03/2021 | 1 |
53TR2020 | CB1_222020 | 15/07/2019 | 1 |
54TR2020 | CB1_232020 | 29/10/2018 | 1 |
56TR2020 | CB1_162020 | 24/11/2017 | 1 |
170TR2020 | CB1_3982020 | 2/03/2020 | 1 |
927TR2021 | CB1_7762021 | 3/04/2021 | 1 |
59TR2020 | CB1_182020 | 15/04/2018 | 1 |
318TR2020 | CB2_702020 | 18/12/2019 | 2 |
436TR2020 | CB3_4172020 | 10/09/2019 | 3 |
968TR2021 | CB1_8182021 | 15/05/2021 | 1 |
60TR2020 | CB1_5802020 | 1/08/2019 | 1 |
61TR2020 | CB1_242020 | 1/10/2017 | 1 |
560TR2020 | CB3_3592020 | 1/02/2020 | 3 |
384TR2020 | CB3_3602020 | 22/11/2018 | 3 |
393TR2020 | CB1_4992020 | 1/08/2020 | 3 |
966TR2021 | CB1_8172021 | 15/05/2021 | 1 |
64TR2020 | CB1_4412020 | 6/05/2019 | 1 |
65TR2020 | CB1_582020 | 1/10/2019 | 1 |
66TR2020 | CB1_592020 | 1/07/2019 | 1 |
57TR2020 | CB1_4022020 | 1/08/2020 | 1 |
68TR2020 | CB1_422020 | 14/02/2018 | 1 |
69TR2020 | CB1_442020 | 27/01/2018 | 1 |
70TR2020 | CB1_452020 | 18/09/2018 | 1 |
171TR2020 | CB1_8012021 | 29/04/2021 | 1 |
661TR2020 | CB2_1912020 | 30/10/2019 | 2 |
699TR2020 | CB3_3822020 | 11/07/2020 | 3 |
780TR2020 | CB2_5922020 | 17/10/2020 | 2 |
342TR2020 | CB2_742020 | 1/06/2020 | 2 |
620TR2020 | CB2_772020 | 1/03/2020 | 2 |
621TR2020 | CB2_782020 | 3/10/2019 | 2 |
963TR2021 | CB2_8142021 | 18/05/2021 | 2 |
838TR2020 | CB2_6732020 | 26/12/2020 | 2 |
623TR2020 | CB2_792020 | 2/02/2019 | 2 |
624TR2020 | CB2_812020 | 12/11/2018 | 2 |
625TR2020 | CB2_822020 | 10/04/2019 | 2 |
698TR2020 | CB3_4182020 | 3/08/2020 | 3 |
388TR2020 | CB3_3612020 | 1/08/2016 | 3 |
626TR2020 | CB2_852020 | 16/04/2020 | 2 |
628TR2020 | CB2_862020 | 14/05/2020 | 2 |
629TR2020 | CB2_892020 | 15/10/2018 | 2 |
618TR2020 | CB2_7502021 | 1/04/2021 | 2 |
I can do a count and it is correct when i a selection on a year or weeknumber he is not responsive and he does not adapt te figures.
What do i do worng?
Solved! Go to Solution.
Not clear what you are trying to do. You can do a count of what? What is InHuizingenPerDatum, a measure? What is its code? What else do you have in the model that is relevant?
Best if you can share the pbix
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Inhuizing per datum is a measure, bewoners contracten is the table above (start) is the amount of that i need.
But when i want to see only the periode of 2017-2019 the data does not change in Datuminhuizingen
For Bree that should be 0 because the site just opened recently
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |