Forum Discussion
Count dimentions with missing values (Desktop May2019 for report server)
I have two tables with one to many relationship and crossfilter direction set to "both". DimDimention (has DimentionID-s) 1 - * DimDimentionUser (has DimentionID's and UserID's) I need to cal...
Hi Anonymous ,
How about the result after you follow the suggestions in other's post? if your ploblem does not resolved, You could also try the following formula.Count = DISTINCTCOUNT ( DimDimentionID[DimentionId] ) - CALCULATE ( DISTINCTCOUNT ( DimDimentionID[DimentionId] ), FILTER ( ALL ( 'DimDimentionUser' ), [DimentionId] & "" <> "" ) )Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JirkaZ
Solution Specialist
Solution SpecialistAnonymous You can add a column to the DimDimension using COUNTROWS(RELATEDTABLE(DimDimensionUser)). Then just count the rows that have 0