How to export distinct values from a measure in a table to a csv

[jjaccesscu]

I have a table a that has several measures that are being displayed

example

member	rate [measure]	amount	targetAcct	calcSum [measure]	totalpermember [measure]	ExportCol
a	1.12%	2	5	0.024	0.1272	5,0.1272
a	1.12%	3	5	0.036	0.1272	5,0.1272
a	1.12%	6	5	0.0672	0.1272	5,0.1272
b	1.12%	7	3	0.084	0.168	3,0.168
b	1.12%	7	3	0.084	0.168	3,0.168
c	1.12%	8	2	0.096	0.096	2,0.096

what I need to be able to export the distinct values of the Column [exportCol] into  a CSV 

the ExportCol is a measure and it needs the other columns in the table to calculate its values

is there a way to do this?

in the above example I want a file with the values

5,0.1272

3,0.168

2,0.096

[Anonymous · Accepted solution]

Thank you lbendlin 

Hi, @jjaccesscu 

As the super user said, you need to implement the metric first. You can do it as follows:

First, I have the following dataset:

I created the following DAX expression:

EVALUATE
VAR _table = SUMMARIZE('Table','Table'[Column1],'Table'[Column2],'Table'[id],"measure",[Measure])
RETURN DISTINCT(SELECTCOLUMNS(_table,[measure]))

Use it in a DAX query view:

Copy it and paste it into your Excel:

In addition, you can also use DAX studio, where the above expression is also available. This tool supports direct export to a file:

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

You need to export all the columns that make the measure unique, then throw them away, and remove duplicates.  That means you need something to process your CSV accordingly.

Alternatively, create a separate visual that materializes the measures and produces the unique values as a column.

[jjaccesscu]

so I have to process the CSV after it is created and I can't  do that within Powerbi/dax as it is being exported?

[lbendlin]

correct.

Alternatively, create a separate visual that materializes the measures and produces the unique values as a column.