Power BI - Sum values based screen filter RRS feed

  • Question

  • 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.

    Wednesday, October 21, 2020 5:23 AM