Forum Discussion
Creating excel tables from Published PI Reports
Does this already exist in your dataset as a Measure? if not then try creating a Measure like
Total Sales =
SUM ( Table[SalesAmount]first in the dataset. That way the calculation is handled by the dataset, and Excel will respect it
Above is how I created the table. But once the table is created, how do I get back to this step above in case I want to add in new columns to the table?
I tried to create a pivot table and would like to apply filters to it but I get the below error. How do I fix this?
Hello homboy27
what types of filters were you trying to use? Excel might not be able to calculate Value Filters on its own since it's a live OLAP connection.
If this is your case, try creating the required measure (like “Total Sales” or “Top N”) in Power BI Desktop and republish the dataset.
I am trying to create a filter for example on customers with sales greater than $100,000