User Profile
GON76
Helper III
Joined 1 year ago
User Widgets
Contributions
Re: Is there a way to count values that are headers?
Hi, unfortunately, I can't share the PBIX file since it's only on our intranet. Here are some screenshots that may be helpful: This is a screenshot of the calculated columns that I'm trying to count: Here's a screenshot of the matrix table with all of the headers expanded: Let me know if there's anything else you would like to see. Thanks in advance!1.5KViews0likes0CommentsIs there a way to count values that are headers?
I have a matrix table that is using headers as rows. I would like to be able to count specific values in the rows. As you can see in the screenshot, the table is showing 3 "Not Compliant" and 3 "Incomplete, but the card counting these field are not accurate. The Not Compliant and Learning Path Completion Status are both caluclated columns. Is there a way to do this?Solved1.6KViews0likes13CommentsRe: Cannot add calculated columns in a pivot table
Hi Akhil, Thanks for responding. I was able to remove the +/- icons. I can only see the Drill Down option when I move the Compliance Status and Learning Path Completion fields to the columns, but then they disappear from the matrix table visual. The table is expanded down all the way. Sorry, I'm a novice at Power BI. Thanks for your help!1.3KViews0likes0CommentsUsing two conditions to return a specific value
I am trying to use two conditions to return a value. I'm using the following formula: Compliance Status = IF(OR ('V_ENROLLMENTS'[EXITDATE].[Date] < EDATE(TODAY(), -3), ISBLANK([EXITDATE])), "Not Compliant", "Compliant" ) I want to show "Not Compliant" for all EXIT dates that are over 3 years old from today and for EXITDATES that are blank. If the EXITDATE is less than 3 years, and the EXITDATE field is populated, I want it to show "Compliant". Is my formula correct?Solved947Views0likes9Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.