Pivot Table Target Measure
Hi guys... I need your help with a measure in Pivot Table with Excel. My goal is to have a measure (DisplayTotalWeeks) based on qty of "SemanaMes". In the case, it must return 9 like the example below. Something like that: Criada em (Month) SemanaMes Qty Atividade DisplayTotalWeeks abr 1 446 9 abr 2 11 9 abr 3 1 9 abr 4 3 9 abr 5 1 9 mai 1 524 9 mai 2 701 9 mai 3 1 9 mai 4 2 9 Grand Total 1690 9 I have stressed ChatGPT, but it doesn't give me what I'm looking for. As an example, I have try this from GPT: TotalUniqueWeeks := COUNTROWS(SUMMARIZE('YourTable', 'YourTable'[SemanaMes])) DisplayTotalWeeks := CALCULATE([TotalUniqueWeeks], ALL('YourTable')) It doesn't return 9, that what I was expecting. So, you are my last hope.
Analysis in Excel with already designed Power BI reports
Hi, I'm searching a way to just export the report which has been designed in Power BI report to excel. But seems it's not convenient by using analysis in Excel function. It will only export the data into a blank pivot in excel. I also found one way to use Power BI publisher add-in in excel to connect to the Power BI report. Is that possible to use Power BU publisher to display the same report in excel ? And where I can download the add-in ? Thanks! Jack