how to make a distinct count in power query that goes with query folding on db

[CCCP]

i have seen many post but without hope and without success in my case,

i have a table, transaction table with different fk and i want a distinct count (that goes natively to my db for processing,in my Oracle).

in particular i want the distinct count of my fk of CARD grouping by all the other remaining columns (fk and the date of the transaction).

Is it possible to achieve this with the GUI of power query or customazing a little the M code behind?

any examples similar to my case on the forum?

thanks

[CCCP]

Hi,

1. because it is just for knowledge,
2. because my FK on CARD is a very long string and i don't want to carry this FK on the model but transform this in  a simple count reducing the space and cardinality of the column.

Thanks for your interest

[audreygerred]

Hi! Is there a reason you need to achieve this in Power Query? You can do a DISTINCTCOUNTNOBLANK function with a DAX measure in Power BI.