Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I'm trying to create a new dimension in the form of a boolean value.
The table looks like the following:
cart_id | payment_status |
1 | pending |
1 | authorised |
1 | captured |
2 | pending |
2 | failed |
with the additional column "success" I wish to mark all "cart_id" with '1' if their payment was authorised and all others with '0'.
The challenge is that one cart_id can have many other payment_status but the only one I care for is "authorised".
cart_id | payment_status | success |
1 | pending | 1 |
1 | authorised | 1 |
1 | captured | 1 |
2 | pending | 0 |
2 | pending | 0 |
Would be super happy for any advise on how to create this dimension in Power BI
Thanks in advance
This calculated column DAX counts the number of times a cart is authorised. If any number is returned then the column is set to 1, otherwise 0.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |