How to plot pie chart correctly without creating additional column

[Bidu]

Hello everyone,

I have one column in my Table with integer values, I want report in a pie chart values > 0 and values == 0, and its percentage, but I dont want to create a additional column with values "YES":: >0 and "NOT":: == 0 for it. Is it possible? I'm newbie on dax (and I think to keep only essential information on Tables, maybe I'm wrong).

[Bidu]

For create the Table and insert the two rows, do I this on Power Query?

[tamerj1]

@Bidu 

From home menu in power bi click on "inset data". The table will be automatically created in power query 

[Bidu]

Thank you for attention

[Bidu]

@tamerj1 nice! Thanks.
Now I wanna know about your experience, which solution is more elegant to make this? Am I right about keep only essential information on Table. My intension is make a clear solution, without being a prolixic model

[tamerj1]

@Bidu 

Let's say your data is a couple of million rows. If you add a column then you're actually adding 2 million cells to your data model. The other solution requires adding 2 cells only. I don't think it is a hard question to answer. 

[tamerj1 · Accepted solution]

Hi @Bidu 

you may create a disconnected single column, two rows table. Inset table manually, rename it like "CetegoryFilter, rename the column "Category" and inter "Yes", "No" in the first two rows. 
place CategoryFilter[Category] in the pie chart along with the following measure 

IF (

SELECTEDVALUE ( CategoryFilter[Category] ) = "Yes",

COUNTROWS (

FILTER ( 

'Table',

'Table'[Value] = 0

)

),

COUNTROWS (

FILTER ( 

'Table',

'Table'[Value] > 0

)

)

)