Count Rows or Sum Columns based on single or Multiple conditions in PowerBI | MiTutorials

[@jitendernegi5526]

hi buddy, thanks a lot , i was stuck while using DAX, after watching this it has resolved. once again tq so much.

[@ankitpant439]

This was helpful. Thank you!

[@bblgl5334]

Really useful! Thank you

[@AbhijitShrikhande]

Useful video. I learned something from it.

[@MITutorials]

Glad to hear it!

[@gulabpreetsingh9985]

I liked the mic ur using, it is giving great voice

[@joseraulesquivelugarte7120]

Thanks! It helped me!

[@RangavittalaSR]

YOU helped me __/\__ Thanks

[@MITutorials]

Glad to hear it!

[@james_msuk]

How do you count distint values from two text criteria?

[@jl8217]

Nice one! Thank you.

[@nickstad1661]

I get the same results.. Im making a line graph but the graph doenst change if i add the quick measure. The quick measure doens't do anything for me.

[@anotherone4657]

Thanks man

[@karthikeyanb6897]

How to Exclude a particular value in a column and filter rest for the values.?

[@arupdattagupta4759]

thank u

[@lebogangomoregie8669]

How do I count two types of values in the same conlumn e.g I have sentiment column with Happy and Unhappy, I want to count both
e.g Customer_Sentiment_Total = CALCULATE(COUNT(Sheet1[Sentiment]),FILTER(Sheet1, AND(Sheet1[Sentiment]="Unhappy", Sheet1[Sentiment]="Happy"))) my AND function does not work

[@MITutorials]

You need to use an OR Statement. Use below.
Customer_Sentiment_Total = CALCULATE(COUNT(Sheet1[Sentiment]),FILTER(Sheet1[Sentiment]="Unhappy" || Sheet1[Sentiment]="Happy"))

[@aakashsharma4490]

But what about multiple conditions? you did for one and two. If we want to work with more than two conditions????

[@prod2one]

chill on the reverb next time.

[@MITutorials]

It ain’t so bad, isn’t it ? 😁