Show All Value in Donut Chart with DAX

[PowerVisualBI]

Hello all
I have a problem with DAX
I have slicer company and month for 3 companies. But there is a need to add one option in the slicer company which is "Consol". When I press the console, then all the values will appear as shown on the donut chart now.

I need a DAX formula when I press a company in a certain month, then the donut chart will display the revenue from that company (I have made a DAX formula). But if I press the console, it will display all the revenue values of each company.
Thanks you

The following is the file
https://drive.google.com/file/d/1nlZhVeagoqqgaCfe5gU6mkKN7Kkd0GYJ/view?usp=sharing

[mahoneypat · Accepted solution]

In that case, you still need the disconnected slicer with

CompanySlicer = DISTINCT(Table1[Company])

and the updated measure (using your original Table1 column in the visual).

NewMeasure = var companyselections = DISTINCT(CompanySlicer[Company])

var table2companies = DISTINCT(Table1[Company])

return IF("Consol" in companyselections, CALCULATE(SUM(Table1[Revenue]), Table1[Company] in table2companies), CALCULATE(SUM(Table1[Revenue]), KEEPFILTERS(treatas(companyselections, Table1[Company]))))

Pat

[PowerVisualBI]

Hi Sir @mahoneypat 
I tried based on your input, but still can't sir. the result is like this, I tried to check in one month, it didn't work. And if you just select the console without selecting the month, the result is the same as this

Or maybe can you send the file to me sir? for me to try to analyze.
Thanks sir @mahoneypat 

[mahoneypat]

Please see the file.

https://drive.google.com/file/d/1K25HgbvCA9Kub0LGtx2DlgHDV2dYHg0t/view?usp=sharing

Pat

[PowerVisualBI]

Sorry sir @mahoneypat , you enabled sensitivity label in Power Bi File, so I can't login
Can you delete it? I would be very helpful if you did. Thank you

[mahoneypat]

Good to confirm that feature is working. My bad. I changed it to Public and updated the link in previous post.

Pat

[mahoneypat]

One way to do that would be to first remove the "Consol" row from your data table, then make a disconnected table that has the Company names and "Console" (one way to do that is with UNION like below).

CompanySlicer = UNION(DISTINCT(Table2[Company]), {"Consol"})

Also, you don't need to make 3 separate measures. A single measure will work and let the visual create the filters you need for each company.

NewMeasure =
VAR companyselections =
DISTINCT ( CompanySlicer[Company] )
VAR table2companies =
DISTINCT ( Table2[Company] )
RETURN
IF (
"Consol" IN companyselections,
CALCULATE ( SUM ( Table2[Revenue] ), Table2[Company] IN table2companies ),
CALCULATE (
SUM ( Table2[Revenue] ),
KEEPFILTERS ( TREATAS ( companyselections, Table2[Company] ) )
)
)

Note that the original Company name field is used in the visual and the disconnected table is used in the slicer.

Pat

[PowerVisualBI]

Thanks for the answer sir @mahoneypat 
Actually the choice of the Company Console also has its own value. But I don't show the value, because I want the value for the company console options from the other three companies. That's why I wrote it has no value like the picture below.

I can't delete the console row from the table and create a disconnected table because this will affect other visualizations.
I just want when I click the console option that appears is the Revenue value of the three companies from the existing DAX formula.
Could you give me a hint?