Forum Discussion

Jyaul1122's avatar
Jyaul1122
Icon for Helper III rankHelper III
1 year ago
Solved

Missing Project Name

Hello, I have a table: Data Date Project  21-Jul-25 Project1 21-Jul-25 Project2 21-Jul-25 Project3 21-Jul-25 Project4 21-Jul-25 Project5 15-Aug-25 Project1 15-Aug-25 ...
Need Help
FBergamaschi's avatar
FBergamaschi
Icon for Super User rankSuper User
1 year ago

Here is the solution, I created a simple data model with dimensuons Date and Projects connected 1 to many to the Facts table you supplied

 

Missing Projects =
VAR ALLPRojects = ALLNOBLANKROW( Project[Project ] )
VAR VisibleProjects = VALUES ( Facts[Project ] )
VAR MissingProjects = EXCEPT( ALLPRojects, VisibleProjects )
RETURN IF ( Project[project count] <> 0, CONCATENATEX( MissingProjects ,Project[Project ], " / " ))

 

 

 

PS I do not understand this code

Total Project = CALCULATE(MAXX(VALUES('Table'[Data Date]),[Project count]),ALL('Table'[Data Date]))

I think you can just write it as follows
Total Project = 

IF (
    [Project count] <>0 ,
    CALCULATE( [Project count], REMOVEFILTERS( 'Date' ) )
)

 

and Projects Minnsing Count becomes = [Total Project] - [Project Count]

 

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

Jyaul1122's avatar
Jyaul1122
Icon for Helper III rankHelper III
1 year ago

FBergamaschi 

Thanks for your reply, its work fine but I have Project slicer on my page. Its need to be work as well selected project also. Please reply ?