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 all
Following scenario:
Have a matrix, ROW is a id of an item, COLUMN is a date and VALUE the percentage of total possible bookings this day. (total 1)
The item can be booked multiple times a day, each booking gives me a number of how much this booking is of the total.
For example booking 1 is 0.4 and booking 2 is also 0.4, then this day has a total/value of 0.8.
This works, every day shows the correct sum of these numbers.
But then i need the total percentage for the whole week. Given screenshot shows that the total does not work.
I would expect the total to be 5.17.
I tried sumx but couldnt get it to work..
Thanks in advance
Solved! Go to Solution.
So i tried reproducing it in a sample file, but there its simply just working..
When joining the tables its also working, so i think i will go this way...
@Anonymous ,
Could you please share some sample data and clarify more details about your requirement?
Regards,
Jimmy Tao
Can you share the formula
There is currently no measure or calc. column in use.
Its just a field from the table.
The sumx formula i tried didnt work, but i never used sumx before so it was just a quick try...
So i tried reproducing it in a sample file, but there its simply just working..
When joining the tables its also working, so i think i will go this way...
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |