Issues with date filter on power bi dashboard

[Gasper_11]

Hello,

on the PB dashboard, I am trying to show different measures per month (SLA Met percentage and Count of unassigned tickets). I have created calendar table, which I have connected to input data, based on which I have calculated beforementioned measures. For SLA Met Percentage, everything works fine, measure is correctly shown per month. the problem occurs, when I try to show count of unassigned tickets per month, as data is not shown. I do not know what the issue could be, as I am using the same date column for both measures.

For help, I thank you in advance!

BR

Gašper

[Andreas-Harlak]

Hi @Gasper_11 ,

if I understand you correctly... you have a DateTable an there you grab the Date for analysis, did you grab the Month from the DateTable or from the connected Table. If yo do not grab it from the DateTable try this first. You can transform Monthnumber oder Name in Power Query directly from the Date for analysis.

Maybe if you have more informations about your datasource and you measure I can help more. 

[Gasper_11]

found the solution, thanks anyway