Forum Discussion
Two same slicer on column
Hello, The office column displays the value from the 'SharePoint List' [Value] that belongs to the filtered month or year (the year and month can be filtered based on month and/or year '2019 Janu...
Hi cleemas ,
You may combine all the Offices columns into a separate column for the Excel data source. Enter into Query Editor, click on columns Office1-Office4 at the same time, then choose "Unpivot Columns" option, you can rename this result column "Attribute" with "Office" . Don't forget to click the "Close & Apply" button.
Then you can create measures like DAX to get total value for per Pointer.
Total sum=CALCULATE (SUM (Table1[Value] ),FILTER (ALLSELECTED(Table1), Table1[Pointer]= MAX(Table1[Pointer])))
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.