Dax Measure: Dividing Totals Filtered by Slicers

[cyncyn_98]

Hello everyone, 

I have been trying to find an article/solution to this, if there is any. 

I would like to have a card that shows uses the totals that are filtered by two different slicers, as a dividing measure. And when the slicers are selected by dates abnd month, the values from those two resulting slicers, the dax measure will correctly divide the values. 

Example: Below I have a table that shows values that are filtered with a fiscal month slicer. 

 Example 2: And I have a week ending date slicer, that will have change the week number everytime a different date is selected. 

Now with the total from the other table when selected on a month, I would like that total divided by the week number filtered. 

Below is the Dax Measure I have now.

Per Week Average GM = DIVIDE( [Adjustment $GM plus Total GM$], SUM('Week Calendar Table'[Week of Month]))

Thanks! 

[v-cgao-msft · Accepted solution]

Hi @cyncyn_98 ,

I guess the slicer containing the [Week end date] field affects the value of the measure [Adjustment ¥ GM plus Total GM$]. You can check it here on the card.

Not sure what the formula is for the measure [adjust $GM plus total GM$], you can try this.

Adjustment $GM plus Total GM$ =
VAR _date_select =
    SELECTEDVALUE ( 'Week Calendar Table'[Week Ending Date] )
VAR _year =
    YEAR ( _date_select )
VAR _month =
    MONTH ( _date_select )
VAR _total =
    CALCULATE (
        SUM ( 'Table'[GM] ),
        FILTER (
            ALL ( 'Week Calendar Table' ),
            'Week Calendar Table'[Year] = _year
                && 'Week Calendar Table'[Month Number] = _month
        )
    )
RETURN
    _total

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[cyncyn_98]

Thank you! @v-cgao-msft