Visualize 4 measures at once - Difficult task

[SpiroswayGR]

Hello, again community,

I would like to create a visualization either with lines or bar charts with the below information

1st measure: Sum Revenue per Date (a stable line that won't be changed  slicers)

2nd measure:  Sum Revenue per Date that will change with slicers.  (I have this one because is the normal measure)

3rd measure: Sum Revenue per Date ( that will change ONLY with slicer "Agent" and will be stable)

4th measure: Sum Revenue per Date ( That will change with the agent slicer and also with any other dynamic slicer on the page)

any solution on that?

Thanks in advance!

[v-shex-msft · Accepted solution]

Hi @SpiroswayGR,

I'd like to suggest you take a look at the following blog to know more about 'all' functions which suitable for your requirements:

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI

Regards,

Xiaoxin Sheng

[SpiroswayGR]

@v-shex-msft  Thank you , yes i used to work with them to find my solution 🙂

[SpiroswayGR]

I found a sideway solution with removing filters but if anyone can think of something better let me know.