Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Card Tile not showing required value

Hello All,

I want to get the Total value of Pending Account Approval i.e. 59 (mark in blue rectangle) into the card tile.

vinitdhakite_0-1669280984587.png

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.

vinitdhakite_0-1669281577131.png

So, How should I get 59 in Card Tile.

 

Let me know anything require,

Thanks.

1 ACCEPTED SOLUTION
TotunG
Resolver I
Resolver I

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. 

View solution in original post

1 REPLY 1
TotunG
Resolver I
Resolver I

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. 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.