Ran across an odd issue at a customer the other day and thought that perhaps marcorusso or someone else familiar with the bowels of DAX could help explain it. I published the PBIX here and it is also attached: https://app.powerbi.com/view?r=eyJrIjoiNDlkODNlMDMtZWZmNy00N2UyLTgwN2EtOGU1N2ZiZmNiNmQxIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9 Basically, the data model is very simple: Customers 1--<>--* Assessments 1--<>--1 Fact I have 2 measures: SumScore = SUM('Fact'[Score]) InvScore = 1 - [SumScore] When I create a bar chart using Date from Assessment and InvScore, something strange happens. If I click a particular customer in a slicer, I get a score for each Date, even though a customer only has a single assessment. What I would have expected is that selecting a customer filters Assessment which then filters the [Score] and only return a value for the single Date that customer has in the Assessments table. Instead, the InvScore measure somehow "sees" the other dates in the Assessment table and calculates a value. Seems odd to me so I figured I'd pose the question out to the group.

The reason is simple: 1 - BLANK() = 1More info in Handling BLANK in DAX article. You probably want to do this: InvScore = VAR __score = [SumScore] VAR __value = (1 - __score) * (NOT ISBLANK(__score)) RETURN __value Marco Russo - SQLBI

Odd Issue with Dates | Microsoft Fabric Community

Open Side Menu

Skip to content

Microsoft Fabric Community
Power BI forums
Desktop

Forum Discussion

Related content

Date relationship issues

Date format issue

Power BI Date Column Issue

Averagex issue

Date issue