Forum Discussion

garridog's avatar
garridog
New Member
7 years ago
Solved

Filter with two different measures

Hi, hope you can help me out. I have 2 different measures, one that counts the rows from a table containing light objects, and another one that counts in a different table the heavy ones; so I want ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi garridog ,

     

    Here we can create a measure as below.

    Measure = var _sele = SELECTEDVALUE('Table'[Type])
var light = COUNTROWS(V_Light)
var heavy = COUNTROWS(V_heavy)
return
IF(_sele = "light",light,IF(_sele= "heavy",heavy,light+heavy))

    Then we can get the result based on the value in slicer.

    For more details, please check the pbix as attached.


    Regards,
    Frank

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi garridog ,

 

Here we can create a measure as below.

Measure = var _sele = SELECTEDVALUE('Table'[Type])
var light = COUNTROWS(V_Light)
var heavy = COUNTROWS(V_heavy)
return
IF(_sele = "light",light,IF(_sele= "heavy",heavy,light+heavy))

Then we can get the result based on the value in slicer.

For more details, please check the pbix as attached.


Regards,
Frank

  • garridog's avatar
    garridog
    New Member
    7 years ago

    Hi v-frfei-msft , thanks for your reply it worked like a charm.