Forum Discussion
Two fact tables with different granularity
Hello, I’m new to Power BI and I come here from the world of Qlik! I have a report with two fact tables: Client incident data Monthly Client numbers (split into Existing clients who were ther...
Thank you I managed to get it working!
I now want to have a chart with a drilldown feature where I start with Quarters and can drill into Months.
How can I achieve that? When I try with this calculation, only Jan is accurate on the graph, for the remaining months - only sum(Table[New]) is displayed.
Thanks!
v-kelly-msft
Community Support
Community SupportHi kasiao ，
Could you provide some sample data with expected output?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!