data export file having issue

[Anonymous]

Hi, 

  i have a data like above.   

After export data while try to open its showing one error like this...

If i click yes ...file will open and data is showing ....but some other error is showing again...

I am using 3 measure as values in Matrix table...With in that M3 measure is like this...

M3 =

VAR _count =CALCULATE ( sum ( 'CombinedPerc'[net_premium] ), 'CombinedPerc'[endt_cert] = 0 )

VAR _percentage =

DIVIDE (

_count,CALCULATE (sum ( 'CombinedPerc'[net_premium]),FILTER (ALLSELECTED ( 'CombinedPerc' ),'CombinedPerc'[LLOYDS BINDER TYPE] = SELECTEDVALUE ( 'CombinedPerc'[LLOYDS BINDER TYPE] )&& 'CombinedPerc'[endt_cert] = 0)),0)

RETURN

IF (

SELECTEDVALUE ( 'CombinedPerc'[LLOYDS BINDER TYPE] ) = "Percentage of Total",

FORMAT ( _percentage, "0.00%" ),

_count)

If i remove this M3 from the visual means not error is coming....Is there any mistake is there in these measure?Plse help?

[V-lianl-msft]

Hi @Anonymous ,

Based on my test, I can't reproduce your issue. Can you provide a sample pbix for me to check the issue?

Please remove any sensitive data before uploading.

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

[amitchandak]

@Anonymous , just check datatype M3 should be varchar? I am having doubt excel is taking this as a decimal and with the % column, it is not working.

Create a column M3 with format and check - Say M4. If M4 works and M3 does not, report and issue  -https://ideas.powerbi.com/ideas/ Variant Data Type export is not working

[Anonymous]

Datatype of M3 is text...

I just remove format from M3...So,now M3 data type in power bi is general..After exporting data there is no issue...If i add format to again in M3  in % column then again same issue is happening...So...Is it a bug ?