Donut not showing both measures

[tb1985]

I have two measures, collected and uncollected which are formatted as measures and correctly show two totals that add to a 100 percent.  You can see they present correctly as cards. However, the donut chart is not showing the split and shows 100 percent  uncollected, which is clearly not correct. I am expecting to see 93.5 per cent green, a small bit grey. Any idea what is causing this?  There is only one page-level filter affecting all visuals and is jsut a filter on business unit.

[amitchandak]

@tb1985 , What is the legend you are using or are using both measures.

[tb1985]

Only filter is page level:

I think the issue DAX related - the uncollected measure is 1-Collected and is just returning blank when it references [Collected]

[Pragati11]

Hi @tb1985 ,

Can you share the dax expressions for your both measures?

Thanks,

Pragati

[tb1985]

Just have, have amended uncollected to:

Uncollected = 
var Qday = [Quarter-day]
var Collectpc = CALCULATE([Cash collected %],FILTER('Date','Date'[Date] = Qday))
return
1-Collectpc

Returns OK on the cards, again not on the donut/table. 

[tb1985 · Accepted solution]

Hi guys,

Thanks for looking into it, but it definitely was  DAX issue - I'm not going to post the full solution here because it won't make sense to anyone, but the answer is very much check your DAX...🙂

[tb1985]

Measure Dax:

Collected = 
var Qday = [Quarter-day]
return
CALCULATE([Cash collected %],FILTER('Date','Date'[Date] = Qday))

Uncollected = 
var Qday = [Quarter-day]
var Collectpc = CALCULATE([Cash collected %],FILTER('Date','Date'[Date] = Qday))
return
1-Collectpc

[Pragati11]

Hi @tb1985 ,

Are you moving both of your measures under VALUES section for the donut or somewhere else?

Can you put a screenshot for this?

Thanks,

Pragati

[tb1985]

Yes, both under values:

If I convert to table it looks like the table collected goes blank:

[Pragati11]

Hi @tb1985 ,

Is there any visual level filter on your Donut chart?

Can you share pbix file?

Thanks,

Pragati