Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
Could you please help to calculate number of rows where filter is 1? I've put this formula but there are wrong calculation:
Hi @Anonymous
How do you tell it's not delivered? CAn you show a sample of your table?Try something like this
Count lines undeliv = CALCULATE ( COUNTROWS ( CDP_data ); FILTER ( 'CDP_data'; 'CDP_data'[Undelivered] = 1 ) )
Hi @AlB not delivered i've counted like that: Negative = if(CDP_data[Undelivered]<0;1;0)
Ok, so then this should work, as a measure in a card visual. If it doesn't, please share a sample of your tables or the pbix:
Count lines undeliv = CALCULATE ( COUNTROWS ( CDP_data ); FILTER ( 'CDP_data'; 'CDP_data'[Undelivered] < 0 ) )
@AlB It's working but calculcation is wrong.
I have columnt oredered, delivered, undelivered which is calculated:
Hi @Anonymous ,
Create a measure as below.
countrows = CALCULATE ( COUNTROWS ( CDP_data ); FILTER ( 'CDP_data'; 'CDP_data'[Negative] =1 ) )
@v-frfei-msft still the same mistake when I have =1, but it counts correctly when i choose =0.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
77 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |