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.
I have 2 tables (Table A and Table B) with a date and Hour column in each plus a Date table.
When I drag date from Date table in Table viz with hour from Table A and Table B it shows hours for April from Table A.
when I drag Status column from Table B in the viz - April disappear as there are no April data in Table B.
How do I get April to appear on the "With status" viz?
Solved! Go to Solution.
hI @Anonymous
try to add these two measures:
Total B Hours = SUM( TableB[Hours B])
Total A Hours = IF( NOT( ISINSCOPE( TableB[status] ) ), SUM( TableA[Hours A] ) )
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Instead of having two fact tables (table A and table B), could you have a single fact table (table A B)? I don't have a solution by way of a DAX language. My first approach would be to denormalize the fact tables into one table. Looking at the available columns, you don't look like you have so much granularity that a single table becomes imposible to understand.
the two tables are at a different granularities.. Table A is at the Date granularity whereas Table B is at the Date and Status granularity
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
hI @Anonymous
try to add these two measures:
Total B Hours = SUM( TableB[Hours B])
Total A Hours = IF( NOT( ISINSCOPE( TableB[status] ) ), SUM( TableA[Hours A] ) )
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
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 |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |