I have a Fact table that looks like this (it's a really small table... I know the design is less than ideal!!!):
CREATE TABLE DiagnosisFact(
I have a Symptom table...
CREATE TABLE DimSymptom (
SymptomName VARCHAR(20) PRIMARY KEY
I can create the DiagnosisCount ... COUNTROWS('DiagnosisFact').
The dumb thing I can't get to work is the Percentage of Total stuff. I must be missing something, but I can't override the SymptomName on the column or row...
I thought it should be:
Pct of Total:=
DIVIDE( [Diagnosis Count], CALCULATE ( COUNTROWS('Diagnosis'),ALL('Diagnosis'[SymptomName]) ) )
but no joy... what am I doing wrong?
For grins, I did this in Excel 2016, and it worked...
=CALCULATE ( [Total Sales], ALL( 'Calendar'[EnglishMonthName] ) )
In terms of this dataset, it would be
= DIVIDE ( [Diagnosis Count], CALCULATE ( [Diagnosis Count], ALL( 'Diagnosis'[SymptomName] ) ) )