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
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
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
yes it already exisits in my data set as a column. who does that it not work if its already in the dataset?