Markus on 15 Jan 2017 23:02:15
In PowerBI Publisher for Excel it is a huge problem that columns in the PivotTable cannot be used as values - only Measures created in PowerBI are allowed as values.
For instance, I mostly use the "ID" column of a table for counting. In a normal Excel PivotTable, this is no problem - I can add the ID as value, click "cell options" and mark "unique count".
This has to be possible with PowerBI Publisher for Excel as well!