How to do a kind of histogram

[Anonymous]

Hi all,

I have this graph and I want to mak a kind of histogram. 

I mean, I want the x axis agrupated by number of sPoliza with the same number os sTomado.

The result would be like this:

Its a very simple group that I think it could be possible to do it without any dax or data transformation. 

Thanks for all

[dax]

Hi markoss92,

According to you description, I think your sample is like below

You could create a column like below

Column = CALCULATE(COUNT(Table1[id]),ALLEXCEPT(Table1,Table1[type]))

Then create  a measure and use this in chart

Measure 2 = CALCULATE(COUNT(Table1[type]),ALLEXCEPT(Table1,Table1[Column]))

Best Regards,

Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi, It Works but now if I want to apply a page filter it doesn't apply.