Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi All.
I have simple data as follow. I want to sum up the Visit Amt if the Room Type is "ROOM".
Created this measure, Total VisitTime = CALCULATE(SUM('Table1'[VisitAmt]),FILTER('Table1', Table1'[Room Type]="ROOM"))
Acct Num | Date | Room Type | Visit Amt |
1 | 8/1/2022 | ROOM | 37 |
2 | 8/1/2022 | ROOM | 53 |
3 | 8/1/2022 | Living | 68 |
4 | 8/1/2022 | ROOM | 41 |
5 | 8/2/2022 | ROOM | 61 |
6 | 8/2/2022 | ROOM | 52 |
7 | 8/2/2022 | Conference | 67 |
8 | 8/2/2022 | Conference | 40 |
9 | 8/2/2022 | ROOM | 98 |
10 | 8/2/2022 | ROOM | 73 |
11 | 8/3/2022 | ROOM | 78 |
12 | 8/3/2022 | Conference | 65 |
13 | 8/3/2022 | Living | 54 |
14 | 8/3/2022 | ROOM | 61 |
15 | 8/4/2022 | ROOM | 40 |
16 | 8/4/2022 | ROOM | 78 |
17 | 8/4/2022 | ROOM | 34 |
18 | 8/4/2022 | ROOM | 67 |
19 | 8/4/2022 | ROOM | 58 |
Total | 1,125 | ||
Ideally should look like this... I'm getting something different when pushing in table or matrix giving the total for listed date.
Solved! Go to Solution.
Hi Tevon,
I tried recreating this using your data and my formulas seem to work, although they are no different from yours.
Only thing I can see is some minor differences in your syntax re apostrophes. Try my DAX below:
If still stuck I can either send you my PBIX where I tried this out, or you could send me yours for review?
Cheers
Hi,
You may download my PBI file from here.
Hope this helps.
Hi @Tevon713 ,
My test result is the same with @MDodds 's. An alternative, you can simply only select ROOM in the visual filter of Room Type column, and just put the VisitAmt column in the visual without a measure.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Tevon,
I tried recreating this using your data and my formulas seem to work, although they are no different from yours.
Only thing I can see is some minor differences in your syntax re apostrophes. Try my DAX below:
If still stuck I can either send you my PBIX where I tried this out, or you could send me yours for review?
Cheers
Link to PBIX if helpful. Cheers
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
70 | |
57 | |
37 | |
36 |
User | Count |
---|---|
85 | |
65 | |
60 | |
46 | |
45 |