count values with filters

[Anonymous]

Hi! Please advice! Look I got table with trucks numbers by cityes and deliveryes by dates and truck numbers. How to do the the measure that will give me the constant value (summ of trucks) all the year long?

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may try using ALL and ALLSELECTED in CALCULATE.

[Anonymous]

Dear @v-chuncz-msft,

Please give the example of this formula.

Thanks!

[v-chuncz-msft]

@Anonymous,

You may check https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/.

[Anonymous]

eugeny, you are requesting a very broad question. We already told you that you can simply CALCULATE the total or COUNTROWS (I wrote you measure=COUNTROWS(table)) but we really can't help you without more detail

[Anonymous]

Not that much information, looks like a simple measure = Countrows (table) and then you apply your measure with your filters, but it's better if you explain with a little more detail