Forum Discussion
Counting function in calculated column instead of measure
column = distinctcount(Dimcustomer[CustomerRank])
instead of
Measure = distinctcount(Dimcustomer[CustomerRank])
I still don't follow why you would want to do that.
There's nothing to stop you doing it, but you'd end up with the same value against each record.
buddy actually i need total of the count column.
I have a calculation like 'Column/total count'
for this um trying to create a column with count and then its total as total count and then i will perform the above calculation.
um unable to create a calculation using both measure and column cus um in DirectQuery mode.
Is it clear now or u want me to elaborate it bit more..??
if it is clear then is there any better way to do that...!!
Ah, ok... So your using Direct Query? In that case, I understand your issue.
As you already know, you can't currently create a DAX measures in Power BI when using the Direct Query connection.
What is your data source?
My personal opinion is, until the ability to add DAX in Direct Query becomes available, Direct Query shouldn't really be used unless your data source is a multi-dimensional or tabular cube.
If you're not using either of these, then unless somebody has an alternative suggestion, I'd look to not using Direct Query.
Hmmm K.
Thanks for your response ianbarker. :smileyhappy: