Power BI - Sum values based screen filter

shabeersa

New Member
Joined
Apr 22, 2013
Messages
5
So I have a Power BI screen that i created via Power BI desktop and the connection is to SharePoint Online List.

I have on my screen 3 elements, a) date slicer to select the date range to b table, B) Table, dynamic filters the data based on A date slicer. C) a card visual to sum the total of that column, example: Shorts

I need help to sum all the values that on column Shorts based on the screen filtered results. So in my screenshot example, the Short sum total should be 67,8

How remember if i move my date slicer to another date range, the B table will display the filtered results and need C to dynamically change the total. Sum of Short.

The SharePoint table name: ParentList
The Shorts field name is: Shorts

How do I do this. Please explain to me in steps.
Thanks
 

Attachments

  • IMG_20201020_230726.jpg
    IMG_20201020_230726.jpg
    183.6 KB · Views: 5

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,118,800
Messages
5,574,399
Members
412,590
Latest member
Velly
Top