Forum Discussion

TheAmazingPBI's avatar
TheAmazingPBI
Regular Visitor
3 years ago
Solved

Help with a calculate, sum and filter function to apply page filters

Hi all Been trying to find a solution on google and this forum for my problem and unable to locate - I'm sure its an easy fix which I can't properly describe.   I am trying to Sum 'Revenue' in the...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago
    =CALCULATE(
    SUM('Table1'[Revenue]),
    'Table1'[BusinessGroup] = "BG1")
olgad's avatar
olgad
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Have you checked the relationship if it is active between the date table and sales table? edit interactions? so there is no accidental click on none, from month filter to  the visual where you display BG1. 

Is it only month filter that doesnt filter or also other slicers?

TheAmazingPBI's avatar
TheAmazingPBI
Regular Visitor
3 years ago

thanks for the quick reply, they all related as the various fields I am filtering by are from the same rows in the same table. e.g. each Business Group has their own Month and all data for business groups is appended to the same table