countrows only selected

[sandrasanchez]

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]);ALLSELECTED(InvoiceSet)) / CALCULATE(COUNTROWS(InvoiceSet);ALLSELECTED(InvoiceSet))

This is my matrix and the solution would be 20/ 15 

Invoice discount = 20 and the number of rows is 15

with a measure it works but I want it to be a column and the result is not as I hope (1.33, Importe 1 is 1.12)

¿Any idea?

Thanks so much!!!!!

[sandrasanchez]

If I do Importe as a measure as you say, when I put a KPI with this value it doesn't summarize correctly unless it is a column that's why I want it to be a column, is not any way of doing it being a column??

thanks so much!!

[sandrasanchez]

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]

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.

[wonga]

@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]

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

sorry if you can't

[Baskar]

Hey Buddy
You have problem with your data modelling or Table Relationship. Please check on this. whenever u getting the same value mean u have prob with your Relationship.

[sandrasanchez]

Sorry, this is the correct link

https://onedrive.live.com/redir?resid=CF098846A6E4E947!421&authkey=!AHNez8ZOAH-5nXI&ithint=file%2cpb...

[sdjensen]

I just cheched out your model. You should calculate Importe1 as a measure not as a calculated column in your table.

[sandrasanchez]

I have uploaded to onedrive

https://onedrive.live.com/?id=root&cid=CF098846A6E4E947

It's the document Ejemplo number of rows

I hope it works

Thanks so much!!!!

[asocorro]

Can you provide the .pbix file?

[sandrasanchez]

Hi Adolfo,

Thank you very much for answering me , but I'm not able to sendo an email, and in your linkedin you haven't your mail published, so I can't contact with you,

thank you any way

[waltheed]

It would indeed be very helpful if you could share your pbix file.

For instance via OneDrive, share the file, and paste the link here.