I have a clustered column chart that shows the percentages of "Status" within each "Group". Examples below with generic labels.
ALLEXCEPT removes all filters apart from GROUP, so this would make sense the filters do not affect it.
You can use a variable instead.Try:
Status% = VAR _group = SELECTEDVALUE ('Table'[Group]) RETURN DIVIDE( DISTINCTCOUNT('Table'[Item ID]), CALCULATE( DISTINCTCOUNT('Table'[Item ID]), 'Table'[Group]) = _group ) ) + 0
Love hearing about Power BI tips, jobs and news?
I love to share about these - connect with me!
Hi Steve, thanks for replying!
I tried that DAX expression and received the following error:
"MdxScript(Model) (9, 5) Calculation error in measure 'Table'[Status%]: DAX comparison operations do not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values."
'Table'[Group]) = _group
from the same table? If not, check that they are the same data type
There is no red line. Below is the expression I entered with actual table/column names.
"Destination Contact Name" is a Text field
"Shipment EXTERNAL ID Type" is a Whole Number field
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.