Forum Discussion

sabeensp's avatar
sabeensp
Helper IV
7 years ago
Solved

Constant Calculated measure value with slicer interaction

Hello, I have a report with bunch of slicers, however all teh slicers value are pinned to same table "Model". I have craeted a Measure as below: MeasureName =  var vNum = CALCULATE (COUNT(TABLE1[C...
Need Help
  • Jorgast's avatar
    Jorgast
    7 years ago

    sabeensp 

     

     

    I belive what Anonymous is referring to is this code:

    var vDen = CALCULATE (SUM(TABLE1[REVENUE] , Filter (Table1, Table1[Year] = 2019) , ALL('Table'[Column])

     

    If this works for you, please accept Anonymous  post.

sabeensp's avatar
sabeensp
Helper IV
7 years ago

Anonymous  Sorry, I'm new to DAX. COuld you please furher elobrate or give me the syntax?

Jorgast's avatar
Jorgast
Resolver II
7 years ago

sabeensp 

 

 

I belive what Anonymous is referring to is this code:

var vDen = CALCULATE (SUM(TABLE1[REVENUE] , Filter (Table1, Table1[Year] = 2019) , ALL('Table'[Column])

 

If this works for you, please accept Anonymous  post.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Jorgast - Yes, that's what I meant - thanks.