Forum Discussion

MarcW's avatar
MarcW
Frequent Visitor
7 years ago

Divide Measure and calculated column issue

Hello, everybody, I have a problem that's been stuck in my head for three weeks.   The situation: In my raw data table there is a value column with 20,000 rows. About 10,000 rows have a value <>0...
WillyW's avatar
WillyW
Frequent Visitor
7 years ago

Hi,

 

I think you need DISTINCTCOUNT instead of count.

Target factor = DIVIDE(2.000.000/DISTINCTCOUNT(value);SUM(Merge[value €]);0)
MarcW's avatar
MarcW
Frequent Visitor
7 years ago

Hi,

 

thanks for your reply. Unfortunalety this doesn`t work, because there are sometimes the same values in each row. With DISTINCTCOUNT I get much less counts than I actually have per line.

 

Thanks!

  • WillyW's avatar
    WillyW
    Frequent Visitor
    7 years ago

    I'd suggest to add a column with unique numbers from 1 to x (or maybe you have order numbers or kind of IDs you can use?), then you should be able to use DISTINCTCOUNT on this column.