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!! ;)

wonga's avatar
wonga
Continued Contributor
10 years ago

sandrasanchez

 

I'm unable to modify anything in "Edit Queries" in your pbix file. Looks like it uses an external data source. Is it possible for you to import the data into the PBIX file so it doesn't rely on connecting to an external data source?

 

Since you want a calculated column, that means Power Query (M) must be used.

  • sandrasanchez's avatar
    sandrasanchez
    Advocate I
    10 years ago

    I have imported the data from external source (Dynamics CRM), you should be able to modify it....

    sorry if you can't