Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Please help me with my problem in DAX.
I have table visual and i need to have a measure looks like below:
VAR CountAllColumn = Count the number of column no matter what is the value
VAR CountWithValue = Count the number of column, filter Measure 1 is not equal 0 or is not equal to blank
RETURN
DIVIDE(CountWithValue, CountAllColumn)
Fields:
on rows: 'Cal'Month(real)
on header: 'Table1'Item Number
on Values: Measure 1
I am using live connection, and the measure that we are using are pre-aggregated in AAS.
User | Count |
---|---|
59 | |
21 | |
18 | |
16 | |
15 |
User | Count |
---|---|
85 | |
54 | |
45 | |
39 | |
21 |