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

  • 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.