How to plot twice a data on the same visual, both with and without filter

[fabiomanniti]

Hello, I have a Histogram where I'm plotting the counting of a Id vs "creation_date".

This Id can also have a state: active, inactive, removed.

I would like to plot on the same histogram the counting of all ids, the counting of active ids and inactive ids.

Probably I should create a DAX formula but my question is: is it possible to make it from Power Bi service, so without any use of DAX?

Thank you

[V-lianl-msft · Accepted solution]

You need to create a measure in the desktop. We can't model it in the service.

[mattww]

You're probably right that DAX would be the preferable solution for this

If you need to do it without DAX, maybe creating artificial rows in your data to count the All or unfiltered results might work. Simple example below