Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Multiple measures in a chart

Hello,

Is there a possibility to create such chart? The tricky point is that I have a slicer and 2 groups - "Active" and "No active". So I have 4 measures - [count of active curr year], [count of no active LY], [count of no active curr year], [count of no active LY] and I use

 Measure =
   SWITCH(TRUE(),
    VALUES('Chart'[Chart type]) = "Active", [count of active curr year]
    VALUES('Chart'[Chart type]) = "No active", [count of no active curr year]
    )
Its good if I want to display only curr year, but I need to display also LY as a requirement
 I somehow would need two measures with Switch, to display curr year and LY of active and no active at the same time (when slicer is active then active of curr year and LY, when no active then curr year and LY of no active). Is there any possibility to do that?

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , You have to create another measure for LY

     

    Measure =
    SWITCH(TRUE(),
    VALUES('Chart'[Chart type]) = "Active", [count of active LY]
    VALUES('Chart'[Chart type]) = "No active", [count of no active LY]
    )

     

    and use these two switch measure in visual

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , You have to create another measure for LY

     

    Measure =
    SWITCH(TRUE(),
    VALUES('Chart'[Chart type]) = "Active", [count of active LY]
    VALUES('Chart'[Chart type]) = "No active", [count of no active LY]
    )

     

    and use these two switch measure in visual