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 everyone!
I would like to create a measure to filter the number of days for 'Cama Alta' for either one of the specific dates listed on the rows. Right now it is adding the number of days for both dates. I need the measure to bring either value, not the sum of them.
Thanks!
Hi @LuisGerardoSR ,
I'm not sure I got your point but you can use it with slicers, so it will filter your data. Also if you are using it on visuais, check the summarization, if it's numeric the default should be sum. You can change it.
If I don't answered you question, please give us more details about what you are doing.
I used the slicer to select the date I want, but it will not give me the correct days. It brings the sum of days for both dates, even if only one date is selected.
I am looking for a measure that will filter out the rows by date and then bring the correct number of days.
The following is a matrix where it lays all the data. It is adding all the values instead of separating them by date.
I am also posting the table where it is pulling everything from.
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 |
---|---|
46 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |