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.
Hi All,
I am trying to display the count of positions in the table but the number is showing 19, but you can see there are clearly only 16 in the data set. Am I missing something?
Thanks
I assume the count of position no in the card is from the table as matrix visual? Slicers are ok but do you have a visual level filter on a matrix that will not propagate to card visual. Can you confirm that? Also, do you have any measure in the matrix visual? if there is are measures in the table visual and return blanks(), those rows will not show in Table visual but will get counted in Card visual. In nutshell, there can be many factors.
@Anonymous , can you share the formula. Just check you are not counting when values are 1 and 0. In that case, it should be a sum.
Here is the dropbox link
https://www.dropbox.com/s/cdglrogv0ufkj86/FTE%20Budgeting%20Test%20file.pbix?dl=0
Hi @Anonymous ,
Sorry for late back. I find that the sample link is not working. Have you resolved the problem? If yes, can you please share the solution? More people will benefit from this thread. If you still need help, please share the sample again.
No I have not figured this out yet, here is the link
https://www.dropbox.com/s/xvrp8oqw3eeax48/FTE%20Budgeting%20Test%20file.pbix?dl=0
Sorry, what formula? (still kind of new to Power BI)
@Anonymous do you have any visual level filter on table visual?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Yes I have these slicers
@Anonymous I assume the count of position no in the card is from the table as matrix visual? Slicers are ok but do you have a visual level filter on a matrix that will not propagate to card visual. Can you confirm that? Also, do you have any measure in the matrix visual? if there is are measures in the table visual and return blanks(), those rows will not show in Table visual but will get counted in Card visual. In nutshell, there can be many factors.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I have these filters effecting the table if thats what you mean
Position No can never be blank so I dont think that is it
Hi @Anonymous ,
Based on the screenshots, I'm still not clear. Can you please share a dummy file and upload it to OneDrive for Business? Then we can test it.
Here is a dropbox link
https://www.dropbox.com/s/cdglrogv0ufkj86/FTE%20Budgeting%20Test%20file.pbix?dl=0
@Anonymous where you put operation is not blank and vice president is not blank(), where you added that filter?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Not sure I 100% understand the question
Is this what you were wanting
@Anonymous where you put this filter conditions, it is from the screen you shared earlier
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |