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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

View discussion in a popup

Replying to:
amitchandak
Super User

Anonymous , if dimension and fact are joined

 

countrows(Table) +0 with dimension should give all the rows with 0 for in used

 

if(isblank(countrows(Table) ),1,blank()) will give you only unused with a member of dimension

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube