Forum Discussion

sandrasanchez's avatar
sandrasanchez
Advocate I
10 years ago

countrows only selected

Hi! I'm trying to create a calculated column with a value (Invoice Discount) divided by the number of rowsç this is my dax function:   Importe1 = calculate(max(InvoiceSet[Invoice Discount]);ALLSE...
sandrasanchez's avatar
sandrasanchez
Advocate I
10 years ago

Hi sdjensen:

if I put it as a measure it works, but I want it to be a column to be able to discount Importe1 so importe would be:

Importe = Importe - Importe 1

Thanks so much for helping me!! ;)

sdjensen's avatar
sdjensen
Solution Sage
10 years ago

Why do you want it as a calculated column?? You should be able to obtain the same just with an extra measure defined as Importe - Importe 1.

 

If you want this new measure to be called Importe then you need to find a new name for the current called Importe.