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.
Estimados Todos
Quiero crear una medida para mostrar todas las transacciones esperan indicador C & H que tienen Enviar a (1).
Por lo tanto, básicamente, quiero eliminar el indicador C & H que es SubmitTo (1) del resultado. ¡Puedes ayudar, por favor!
Gracias
Gaurav
Enviar a | Número | InvoiceDetailID | InvoiceID | Cantidad | Indicador |
0 | 79218257 | 2309645 | 867026 | 500 | A |
0 | 79218279 | 2309646 | 867028 | 1250 | A |
0 | 79218279 | 2309647 | 867028 | 2000 | A |
1 | 79218279 | 2309648 | 867028 | 2750 | C |
1 | 79218299 | 2309649 | 867029 | 3500 | C |
1 | 79218299 | 2309650 | 867029 | 4250 | C |
1 | 79218299 | 2309651 | 867029 | 5000 | A |
1 | 79218313 | 2309652 | 867030 | 5750 | A |
1 | 79218316 | 2309653 | 867030 | 6500 | F |
1 | 79218318 | 2309654 | 867030 | 7250 | F |
1 | 79218330 | 2309655 | 867031 | 8000 | F |
1 | 79218335 | 2309656 | 867031 | 8750 | F |
1 | 79218345 | 2309657 | 867031 | 9500 | F |
2 | 79218351 | 2309658 | 867031 | 10250 | H |
2 | 79218355 | 2309659 | 867031 | 11000 | H |
2 | 79218357 | 2309660 | 867031 | 11750 | H |
2 | 79218371 | 2309664 | 867050 | 12500 | H |
2 | 79218374 | 2309667 | 867052 | 13250 | H |
1 | 79218351 | 2309658 | 867031 | 10250 | H |
1 | 79218355 | 2309659 | 867031 | 11000 | H |
1 | 79218357 | 2309660 | 867031 | 11750 | H |
1 | 79218371 | 2309664 | 867050 | 12500 | H |
1 | 79218374 | 2309667 | 867052 | 13250 | H |
2 | 79218279 | 2309648 | 867028 | 2750 | C |
2 | 79218299 | 2309649 | 867029 | 3500 | C |
2 | 79218299 | 2309650 | 867029 | 4250 | C |
Resultado
SubmitTo | Número | InvoiceDetailID | InvoiceID | Cantidad | Indicador |
0 | 79218257 | 2309645 | 867026 | 500 | A |
0 | 79218279 | 2309646 | 867028 | 1250 | A |
0 | 79218279 | 2309647 | 867028 | 2000 | A |
1 | 79218299 | 2309651 | 867029 | 5000 | A |
1 | 79218313 | 2309652 | 867030 | 5750 | A |
1 | 79218316 | 2309653 | 867030 | 6500 | F |
1 | 79218318 | 2309654 | 867030 | 7250 | F |
1 | 79218330 | 2309655 | 867031 | 8000 | F |
1 | 79218335 | 2309656 | 867031 | 8750 | F |
1 | 79218345 | 2309657 | 867031 | 9500 | F |
2 | 79218351 | 2309658 | 867031 | 10250 | H |
2 | 79218355 | 2309659 | 867031 | 11000 | H |
2 | 79218357 | 2309660 | 867031 | 11750 | H |
2 | 79218371 | 2309664 | 867050 | 12500 | H |
2 | 79218374 | 2309667 | 867052 | 13250 | H |
2 | 79218279 | 2309648 | 867028 | 2750 | C |
2 | 79218299 | 2309649 | 867029 | 3500 | C |
2 | 79218299 | 2309650 | 867029 | 4250 | C |
Solved! Go to Solution.
@gaurav-narchal , agregue esta medida a visual.
if(max([Submit To]) ?1, if(max(Indicator) in ''H', 'C'' , blank(), countrows(Table)),countrows(Table))
Toda la medida en visual debe seguir esta lógica
Por favor considere esta solución y deje felicitaciones
Por favor considere esta solución y deje felicitaciones
@gaurav-narchal , agregue esta medida a visual.
if(max([Submit To]) ?1, if(max(Indicator) in ''H', 'C'' , blank(), countrows(Table)),countrows(Table))
Toda la medida en visual debe seguir esta lógica
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 |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |