Calculating groups
Dear community, I am facing a challenge to group sales from a fairly simple table. The table have total sales generated on both "OrderType" and "SalesChannel" which sums up to the same. However I would like to change the setup with the following needs, preferably through dax (running direct query): "Dining-In Sales" should only appear once "Pick-Up Sales" should be zeroed "Online Sales" should be calculated as follows: Online Sales - all Providers Sales The decired result you can see on the right hand side. Thanks in advance.
Problem with Chiclet Slicer on Grouped field on IE 11. PBI Desktop & Report Server -May 2019 Update
Hi, I have implemented a simple report that merely displays a matrix with values imported into power bi. Data is pivoted in Power BI. Even then, the row count is just about 100,000 rows * Page uses Sync slicers and Book marks (Updated book marks and verified that are no errors wrt visuals) * Pages uses Grouping of Weeks and Chiclet slicer is used to show both grouping as well as associated Week numbers. There is a one way interaction Week grouping --> Week no * There are a few other drop down slicers (part of default PBI package) On selection of Week number, the report results in an error and it navigates to default report page. The problem is only on IE 11. Report works fine on Chrome. Also, I have used the same version of chiclet slicer in other reports and in other pages of the same report. The problem is only when used both grouped field and field is used in the same page (Week grouping and Week for example)
