Export a detailed data from a card to excel ( not summarized )

[Mani1205]

Hi Experts,

I have created a measure using it in a card ( like covered orders and not covered orders ) and i wanted to export covered orders & not covered orders from that card - is it possible 

[Anonymous · Accepted solution]

Hi @Mani1205 

Please correct me if I wrongly understood your question.

I create a data table like this :

And create two measures to count the number of “covered” and “uncovered” , then use two measures in card visual .

count of uncovered = CALCULATE(COUNTA('Table'[Status]),FILTER('Table','Table'[Status]="uncovered"))

count of covered = CALCULATE(COUNTA('Table'[Status]),FILTER('Table','Table'[Status]="covered"))

When I export the data in card visual , the effect is as shown , so card visual cannot export the data you want .Maybe you can create a table visual and add the fields you want ,then to export the data .

Best Regards

Community Support Team _ Ailsa Tao

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

[amitchandak]

@Mani1205 , for that, create a drill-through report and use that for export

https://www.youtube.com/watch?v=NVGjthYx_4Q