Forum Discussion
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...
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.
I have imported the data from external source (Dynamics CRM), you should be able to modify it....
sorry if you can't