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.
Current Fomulas:
Once filtering by 'Contact' (Table)
HIT Card F Ct = COUNTAX(FILTER('HIT Card','HIT Card'[Complete]=FALSE()),'HIT Card'[Complete]) -- counting total False rows
This is currently giving me exactly what I'm looking for.
However, I would like to create a formula that finds the total COMPLETE Days over total days with a record.
Complete Day = Two Entries per day, each entry equals to TRUE
e.g.
I would like to see another table that show
Sunday, April 02, 2023 = FALSE -- because I have one True and one False
Tuesday, April 18, 2023 = FALSE -- because it does NOT have at least two entries
Every other date shown in this table would show a value for TRUE.
Please let me know if you need more information!
Current data model
Calendar is filtering Hit Card (Calendar[Date] -> Hit Card[Date])
Contact is filtering Hit Card (Contact[Id] -> Hit Card[Supervisor])
A Formula I have so far to fix this issue.. However, I'm not sure If I'm on track and I keep getting this error.
@parry2k @Greg_Deckler @amitchandak @Ritaf1983
@lbendlin @Idrissshatila @christinepayton @CoreyP
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
This is my updated formula
This picture above is me filtering the 'Contact'[Name]
As you can see my current formula is Wrong (slightly)
According to the table the Complete Days should be 3 instead of 4
Date | Complete | HIT Card Name | Name |
4/24/2023 0:00 | true | HIT-19684 | Bryan Jasper |
4/24/2023 0:00 | true | HIT-19685 | Bryan Jasper |
4/25/2023 0:00 | false | HIT-19739 | Bryan Jasper |
4/26/2023 0:00 | true | HIT-19775 | Bryan Jasper |
4/26/2023 0:00 | true | HIT-19777 | Bryan Jasper |
4/28/2023 0:00 | true | HIT-19875 | Bryan Jasper |
4/28/2023 0:00 | true | HIT-19876 | Bryan Jasper |
The second screenshot shows a "correct" number being 14 (even though for Friday, August 4, 2023 has 3 records)
This seems to be working because all are TRUE.
Date | Complete | HIT Card Name | Name |
4/1/2023 0:00 | true | HIT-18380 | Anthony Winslow |
4/1/2023 0:00 | true | HIT-18381 | Anthony Winslow |
4/2/2023 0:00 | true | HIT-18431 | Anthony Winslow |
4/2/2023 0:00 | true | HIT-18432 | Anthony Winslow |
8/3/2023 0:00 | true | HIT-24132 | Anthony Winslow |
8/3/2023 0:00 | true | HIT-24133 | Anthony Winslow |
8/4/2023 0:00 | true | HIT-24172 | Anthony Winslow |
8/4/2023 0:00 | true | HIT-24173 | Anthony Winslow |
8/4/2023 0:00 | true | HIT-24211 | Anthony Winslow |
8/5/2023 0:00 | true | HIT-24232 | Anthony Winslow |
8/5/2023 0:00 | true | HIT-24235 | Anthony Winslow |
8/6/2023 0:00 | true | HIT-24294 | Anthony Winslow |
8/6/2023 0:00 | true | HIT-24295 | Anthony Winslow |
8/7/2023 0:00 | true | HIT-24334 | Anthony Winslow |
8/7/2023 0:00 | true | HIT-24335 | Anthony Winslow |
8/8/2023 0:00 | true | HIT-24391 | Anthony Winslow |
8/8/2023 0:00 | true | HIT-24392 | Anthony Winslow |
8/9/2023 0:00 | true | HIT-24431 | Anthony Winslow |
8/9/2023 0:00 | true | HIT-24432 | Anthony Winslow |
8/10/2023 0:00 | true | HIT-24516 | Anthony Winslow |
8/10/2023 0:00 | true | HIT-24517 | Anthony Winslow |
8/11/2023 0:00 | true | HIT-24570 | Anthony Winslow |
8/11/2023 0:00 | true | HIT-24571 | Anthony Winslow |
8/12/2023 0:00 | true | HIT-24626 | Anthony Winslow |
8/12/2023 0:00 | true | HIT-24627 | Anthony Winslow |
8/26/2023 0:00 | true | HIT-25170 | Anthony Winslow |
8/26/2023 0:00 | true | HIT-25171 | Anthony Winslow |
8/27/2023 0:00 | true | HIT-25172 | Anthony Winslow |
8/27/2023 0:00 | true | HIT-25173 | Anthony Winslow |
Reminder:
Complete Day = Two Entries per day (at least), each entry equals to TRUE ( unless there is more then 2 entries, then as long as two are equal to TRUE)
@lbendlin
That's not good sample data. Ideally the sample data would cover all scenarios, including false and single entries.
You have both of those. The first sample has a false and happens to be a single entry as well.
Are or can you help me with this?
Sorry, I had ignored the colored table.
Complete Days =
COUNTROWS (
FILTER (
SUMMARIZE ( Contact, [Date], [Complete], "ct", COUNTROWS ( Contact ) ),
[Complete] = TRUE () && [ct] > 1
)
)
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 |
---|---|
96 | |
92 | |
81 | |
70 | |
64 |
User | Count |
---|---|
115 | |
106 | |
96 | |
81 | |
72 |