Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!!!!!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.