Percent of select text values to display in column so that the data can be exported in CSV

[lilkjun1]

Hello my PBI gurus! I'm very new to the PBI data and DAX world so to say I'm struggling is an understatement but I'm smiling along the way 🙂

I'm looking to get a percentage of certain text values but have those values displayed within a column so that I can export a csv file to import into another data platform. 

I created 3 measures and they are working but I need the total percent value to be displayed within a row so that it may be exported after slicing the data. My values are Yes, NC and No. 

Measure 1:

_incompliance =

CALCULATE(

COUNTA('Fallouts'[Answered]),

'Fallouts'[Answered] IN {"Yes","NC"}

)

Measure 2:

overallCount =

CALCULATE(

COUNTA('Fallouts'[Answered]))

Measure 3: 

OverallCompliance = ([_incompliance]/[overallCount])

My visual is showing once sliced on the product in question: 

What I need is the 50% to be data within a column so I can export it, currently if I export it, it doesn't include the totals. 

All help is appreciated, Thanks in advance!!

[Icey]

Hi @lilkjun1 ,

Currently, it is not supported to export to excel with total values. And here is a similar idea you can vote up: Microsoft Idea  · Enable 'total row' also to be exported. (powerbi.com).

As a workaround, you can put total row into the Table visual and then it can be exported.

Here is a blog describes how to put total row/column in front of the Matrix visual and it will work in Table visual, too. You can refer to it: How to put the row and column subtotals in front o... - Microsoft Power BI Community.

Best Regards,

Icey

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

[lilkjun1]

Hey Icey, Thanks for the heads up on the total functionality; I voted it up. I'm going to try to apply the workaround within the next couple of days and I'll reply if it worked or not. Of course it's not the same scenario but close and definitely worth a try. Thanks for the reply, I'll keep you posted!!

No Luck; Because I'm using a measure for my calculation I cannot recall it within the Summarize function.

[Icey]

Hi @lilkjun1 ,

Could you share me some sample data for test? Then I can test directly for you.

In addition, please don't contain any sensitive information or real data.

Reference: How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,

Icey