Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
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.
@Mani1205 , for that, create a drill-through report and use that for export
https://www.youtube.com/watch?v=NVGjthYx_4Q
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |