Forum Discussion

KristyP's avatar
KristyP
Icon for Helper I rankHelper I
3 years ago
Solved

DAX Calucation

Hi,   I have two related tables. I am trying to find a value in one table based on a range ( min & max) and a category from the first table. The value I require is in the second table, seperate col...
  • KristyP's avatar
    KristyP
    3 years ago

    Sure, I can do this tomorrow.

devanshi's avatar
devanshi
Icon for Helper V rankHelper V
3 years ago

first make the measure of total sales.
then create one table which include all ranges according to your range you want.

then use this measure:

rangevalues = Calculate([totalsale measure name],
VAR currentrange=

FILTER(

table1,table2,

AND(tablename[value]<=range tablename,

          tablename[value]>=range tablename))

RETURN

  rangevalue
) 

  • KristyP's avatar
    KristyP
    Icon for Helper I rankHelper I
    3 years ago

    With reference to the total sales measure, which column from which table are you referring to?