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,
could anyone help me here please? I've spent hours on a (I think) simple logic query, but I'm not able to get the right results:(((
I need to calculate number of invoices (lines), that
1. have a number > 0 in column A
2. AT THE SAME TIME have number 0, if in column B there is EDIAUTO
Solved! Go to Solution.
Hello @KatkaS
I believe this will give you what you are looking for.
Measure = CALCULATE( COUNTROWS ( 'Table' ), FILTER ( 'Table', 'Table'[PHWSID] = "EDIAUTO" || 'Table'[APPORD] > 0 ) )
This will count every row in the table where
[PHWSID] = "EDIAUTO"
or
[APPORD] > 0
Hello @KatkaS
I believe this will give you what you are looking for.
Measure = CALCULATE( COUNTROWS ( 'Table' ), FILTER ( 'Table', 'Table'[PHWSID] = "EDIAUTO" || 'Table'[APPORD] > 0 ) )
This will count every row in the table where
[PHWSID] = "EDIAUTO"
or
[APPORD] > 0
Ohmy, thank you so much for such a quick reply!!! You saved my sanity!!!!!
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |