Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Need help with a columnL
I've created a couple of columns, one to count the number of daily maintenance has been done for each machine. It appears to be counting (and totaling) correctly:
I've also created a table called Quarters, and I created a measure to caluculate the NetworkDays have occured in each quarter. It shows the correct number in each quarter, then I created a link between the Quarters and Calendar tables. It kinda works, but doesn't show totals correctly (I only highlighted one column, but none of them are totalling correctly:
Any ideas?
https://drive.google.com/file/d/1gYT7lEYbV1xyVu6ug2jCOl-z5YiaD329/view?usp=sharing
Solved! Go to Solution.
Hi @roehler ,
After analysing your query and looking at your file, I tried to re-produce the scenario and here are the steps that will help you with getting the right numbers on your matrix-
1. You can create a Quarter column in the Daily Maintenance table as a calculated column-
Attached file for reference.
Hi @roehler ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution other members can easily find it.
Thank You
Yes, I did, and none of them resulted in a fix for me. I'll continue to look myself.
Hi @roehler ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution other members can easily find it.
Thank You
Hi @roehler ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution other members can easily find it.
Thank You
Hi @roehler ,
After analysing your query and looking at your file, I tried to re-produce the scenario and here are the steps that will help you with getting the right numbers on your matrix-
1. You can create a Quarter column in the Daily Maintenance table as a calculated column-
Attached file for reference.
Hi @roehler
If you're trying to sum up the count of working days for each location, this measure should work. Note: If a location doesn't have a record for that quarter, the measure will return blank as DAX cannot assign a value to a row that doesn't exist.
WorkingDays =
SUMX ( VALUES ( 'Daily Maintenance'[Location] ), SUM ( Quarters[NetworkDays] ) )
maybe you can try to create a measure
measure= sumx(values(location),[WorkingDays])
Proud to be a Super User!
I realized, it's showing the totals in the Device row and the Location row. I went into the settings, and removed the totals for the location row, now it looks like this:
Now it shows a row only for the device, and not the totals for the location, which is fine. I just don't see how it's calculating the working days. There are 9 rows (X 62, should be 558) showing the working days, but its totaling to 434.
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |