Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All,
I want to get the Total value of Pending Account Approval i.e. 59 (mark in blue rectangle) into the card tile.
Right now, some random number (50) is showing in card tile. I put account_payment_approval_value column into filter and select only Pending Account Approval but it show some random 7 no.
So, How should I get 59 in Card Tile.
Let me know anything require,
Thanks.
Solved! Go to Solution.
Are you definitly using the 'SUM' of the Pending Account Appoval in your field? Check by clicking the arrow / drop down on the 'Number of Pending Account Approvals' Field area.
If so, then you could create a DAX measure to give this value. For example:
Total Pending Account Approval: SUMX('Table','Table'[Pending Account Approval]).
Then use this measure in your card.
Are you definitly using the 'SUM' of the Pending Account Appoval in your field? Check by clicking the arrow / drop down on the 'Number of Pending Account Approvals' Field area.
If so, then you could create a DAX measure to give this value. For example:
Total Pending Account Approval: SUMX('Table','Table'[Pending Account Approval]).
Then use this measure in your card.
User | Count |
---|---|
106 | |
88 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |