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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
zy1919
Regular Visitor

Create new tale count of True/False/null in for each column in dynamic report

Hi,

 

I am quite new to PowerBI. I have a table with ID, ColA to D. How can I show a count of True/False/null in for each column as part of my Report?

 

Given:

IDCol ACol BCol CCol D
id1TrueTrueFalse 
id2FalseTrue  
id3False   

 

Result: 

 Count TrueCount FalseCount Null
Col A120
Col B200
Col C012
Col D003

 

The table need to dynamically change with rest of the tables/charts in PowerBI report. For example, when only id1& id2 are selected, then the count in the table can adjust accordingly. 

 Count TrueCount FalseCount Null
Col A110
Col B201
Col C011
Col D002
3 REPLIES 3
zy1919
Regular Visitor

Hi, 

 

Thank you, I was able to create the Attribute table. When I try to select a certain attribute, it does not dynamically update other measure/tables in my report. I checked the Models and they are linked by Id both ways. I just want to be able to select an attribute and see what it looks like in the original table. 

 

For example, in my reports I have the original table and the table created from unpivoted columns. When I selected Count of True for Col A, the original table does not show the only colum with this attribute. 

v-yangliu-msft
Community Support
Community Support

Hi  @zy1919 ,

 

Have you solved your problem? If it's solved, you can mark the correct answer, if not, provide more detailed information and we can help you better.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

danextian
Super User
Super User

Hi @zy1919 ,

 

First, you need to unpivot your Col Columns.  Please see attached sample pbix for reference.

danextian_0-1716264116329.png

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors