Allexcept measure issue

Question

Hi,&nbsp;The goal is to conditionally format a measure (background color) depending on selected filters.Constrains, all data dim and fact are in one table.In order to get to my final measure i had to create some nesting first:1. Number of Vuln day =&nbsp;SUM('Fact daily'[count])2.&nbsp;Vuln wo sev =CALCULATE([Number of Vuln day],&nbsp; &nbsp; ALLEXCEPT('Fact daily', 'Fact daily'[Severity]))That allowed me to create a Divide measure - crucial for result as each of severities should add up to 100% in column total.% of Vuln = CALCULATE(&nbsp; &nbsp; DIVIDE([Number of Vuln day],[Vuln wo sev]))&nbsp;With conditional formatting of % of Vuln&nbsp;&nbsp;Now my problem starts when i try to filter report by department (also as a part of same table)I seek for a measure that upon selection will calculate results to 100% for all severities, not only filtered part of data:I can achieve this result by using Number of Vuln day measure and showing calculation by "Percent of column total", but then logic used to conditionally format fields won't apply.Does anyone have an idea how to resolve this?Lastly, measure for conditional formatting:format risk = SWITCH (&nbsp; &nbsp; TRUE (),&nbsp; &nbsp; &nbsp;[% of Vuln] = BLANK(),"#fe9180",&nbsp; &nbsp; SELECTEDVALUE ( 'Fact daily'[Age categories] ) = "0-30 days"&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; SELECTEDVALUE ( 'Fact daily'[Severity] ) = "Critical"&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; [% of Vuln] &gt;= 0.85, "#33ac7f",&nbsp; &nbsp; SELECTEDVALUE ( 'Fact daily'[Age categories] ) = "31-60 days"&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; SELECTEDVALUE ( 'Fact daily'[Severity] ) = "Critical"&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; [% of Vuln] &lt;= 0.15&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; [% of Vuln] &gt; 0, "#f7dd7e",&nbsp; &nbsp; (&nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE ( 'Fact daily'[Age categories] ) = "0-30 days"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || SELECTEDVALUE ( 'Fact daily'[Age categories] ) = "31-60 days"&nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; SELECTEDVALUE ( 'Fact daily'[Severity] ) = "High"&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; [% of Vuln] &gt;= 0.95, "#33ac7f",&nbsp; &nbsp; SELECTEDVALUE ( 'Fact daily'[Age categories] ) = "61-90 days"&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; SELECTEDVALUE ( 'Fact daily'[Severity] ) = "High"&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; [% of Vuln] &lt;= 0.1&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; [% of Vuln] &gt; 0, "#f7dd7e",&nbsp; &nbsp; (&nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE ( 'Fact daily'[Age categories] ) = "0-30 days"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || SELECTEDVALUE ( 'Fact daily'[Age categories] ) = "31-60 days"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || SELECTEDVALUE ( 'Fact daily'[Age categories] ) = "61-90 days"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || SELECTEDVALUE ( 'Fact daily'[Age categories] ) = "91-120 days"&nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; SELECTEDVALUE ( 'Fact daily'[Severity] ) = "Medium"&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; [% of Vuln] &gt;= 0.98, "#33ac7f",&nbsp; &nbsp; SELECTEDVALUE ( 'Fact daily'[Age categories] ) = "121-180 days"&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; SELECTEDVALUE ( 'Fact daily'[Severity] ) = "Medium"&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; [% of Vuln] &lt;= 0.1&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; [% of Vuln] &gt; 0, "#f7dd7e",&nbsp; &nbsp; (&nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE ( 'Fact daily'[Age categories] ) = "0-30 days"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || SELECTEDVALUE ( 'Fact daily'[Age categories] ) = "31-60 days"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || SELECTEDVALUE ( 'Fact daily'[Age categories] ) = "61-90 days"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || SELECTEDVALUE ( 'Fact daily'[Age categories] ) = "91-120 days"&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || SELECTEDVALUE ( 'Fact daily'[Age categories] ) = "121-180 days"&nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; SELECTEDVALUE ( 'Fact daily'[Severity] ) = "Low"&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; [% of Vuln] &gt;= 0.98, "#33ac7f",&nbsp; &nbsp; SELECTEDVALUE ( 'Fact daily'[Age categories] ) = "180-360 days"&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; SELECTEDVALUE ( 'Fact daily'[Severity] ) = "Low"&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; [% of Vuln] &lt;= 0.1&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; [% of Vuln] &gt; 0, "#f7dd7e",&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; "#fe9180")&nbsp;&nbsp;

lbendlin · Answer

and showing calculation by "Percent of column total", but then logic used to conditionally format fields won't apply
Correct. you will need to implement that logic inside your measure.
&nbsp;
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216 Please show the expected outcome based on the sample data you provided. https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Forum Discussion

Allexcept measure issue

1 Reply

Related content

Filtering with ALLEXCEPT()

Allexcept

Averagex issue

Issue with measure

Filter and Allexcept