I'm relatively new to the world of Power BI so apologies if this is relatively obvious to some of you...
I have a list of ID numbers that are duplicated within a multi-year dataset. I need to create a series of measures that return distinct counts of these ID numbers for each year and then a related measure showing the variance or % change between different years. I want to display these measures in a multi-row card visualisation.
I've been able to display a distinct count of IDs by year using various chart and matrix visualisations but I'm struggling to produce the measure in DAX that will display the distinc count alongisde the variance/% change in a multi-row card. Here's an example dataset:
Any suggestions would be gratefully received!
Solved! Go to Solution.
@arp Please try below two as "New Measure"
Test101Count = DISTINCTCOUNT(Test101Measure[IDNumber])
Test101Variance = VAR _CurrYear = DISTINCTCOUNT(Test101Measure[IDNumber]) VAR _PrevYear = CALCULATE(DISTINCTCOUNT(Test101Measure[IDNumber]),FILTER(ALL(Test101Measure),Test101Measure[Year]=SELECTEDVALUE(Test101Measure[Year])-1) ) VAR _Var = ((_CurrYear-_PrevYear)/_CurrYear)*100 RETURN _Var
This will be a conference that you do not want to miss!
Don't miss the Power BI Dev Camp this week!
Check out a full recap of the month!
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.