Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
So i have this dashboard where im trying to create a function where i have two if's logicals results.
When i do It like so:
Name = If(isblank('protocolos 1[tempo em atendimento]) && 'protocolos 1[status] = "Aberto" && 'protocolos 1[comunicação] = "Passivo", return a logical count.
But like that actually Works, but not complety to acquire the result i want, thats why i tried putz together this
" && If(isblank('protocolos 1[tempo em atendimento]) && 'protocolos 1[status] = "Fechado" && 'protocolos 1[comunicação] = "Passivo" (...)"
But It keeps returning me a boolean value out of the column results, any thoughs about It?
Yes, in this mean while i posted i used only one & but It retorned a weird big number in think It sum them?
@ChrisRafer5 Not clear to me what exactly you are trying to accomplish but you are logically and'ing ( && ) two values which means that you will get a boolean value as a result. Basically your formula can be broken down to
(some number) && (some other number)
That is going to return TRUE or FALSE.
| User | Count |
|---|---|
| 57 | |
| 43 | |
| 32 | |
| 16 | |
| 13 |
| User | Count |
|---|---|
| 84 | |
| 70 | |
| 38 | |
| 27 | |
| 24 |