Dax formula
Dear all, I'm new to the Power BI environment so be patient with me. I have created a report for my project financial overview. I have a matrix table where the rows are the project hierarchy (main and subs) in a nested layout. In columns i have the Contracted amount, Invoiced amount, budget, costs etc. Now i have created a measure that will calculate the unbilled amount based on my cost progress (if result=<0,0,result). My issue there is that in the total row of the table it will not sum the results of the lines (Green) but it will calculate the value based on the total line results (Red). Does anyone knows a trick or a different type of calculation i could make, in order to not change the visual i have currently?
Visualization Not working as needed with dax measure
Visualization drill down not showing. I can only drill through the non-compliant data and not the compliant ones. I have created a formula to check how much data is compliant and non-compliant. For example, if the customer has all the fields populated then he is compliant, so their details are missing from the Query1 table. If the member has a missing information, then he is non-compliant and will be available in the query table. Compliant Formula = DISTINCTCOUNT('DW v_Member'[MemberNum])/CALCULATE(DISTINCTCOUNT(Query1[MemberNum]),ALL(Query1)) Non-Compliant= 1- ( DISTINCTCOUNT('DW v_Member'[MemberNum])/CALCULATE(DISTINCTCOUNT(Query1[MemberNum]),ALL(Query1))) I have also created a calculated column in the member table to check if I can showcase both compliance and Non-compliance data but that is also not working Compliance Check = IF( COUNTROWS( FILTER( Query1, Query1[MemberNum] = 'DW v_Member'[MemberNum] ) ) > 0, "Non Compliant", "Compliant" ) Table information : Dw_Member: is a fact table with all customer information Branch is a fact table with all of company branches Date table Query 1 comprises of only those customers whose profile has a missing information for example date of birth or address etc. A customer can appear more than once if they have multiple information missing Donut chart appears correctly with compliant and non-compliant measures but all other measures are not getting drilled through see second chart
