I have data like below
I need to count only "Yes".
I tried with count distinct but for order 112 it is counting only "No".
I need to count "Yes" even if 1st row entry in data is "No"
Create a column using contains( ) like below.
Count = IF(CONTAINS('table','table'[Flag],"Yes"),1,0)
Can't promise simple, but I have something ...READ MORE
you can automatically get a profile for ...READ MORE
Chop your dataset into 500 sets, each ...READ MORE
The only solution possible by code - ...READ MORE
You can Use Publish to web feature. ...READ MORE
Having knowledge about these topics is a must.
Power ...READ MORE
format the KPI by selecting the paint ...READ MORE
Power BI report server is deployed on-premises ...READ MORE
You can create a new column by ...READ MORE
You can try duplicating the category columns ...READ MORE