https://community.fabric.microsoft.com/t5/Report-Server/Weird-Bug-or-nice-feature/m-p/671857#M10087 <P>Hello,</P><P>I build a report based on direct query to a MSSQL DB (SSISDB) in the PBIRS Desktop. Now I have a weird problem If I create a table with some columns and a separate card visual with a distinct count I get a blank (All data is in the same table - no relationships). BUT If I delete the columns with format date (no matter which) the count counts. Is this normal or is it because it's PBIRS :D?</P><P>Best Kathrin</P><P>&nbsp;</P><P>Picture One - without any columns with "date" format</P><P>Picture two - with date columns</P><P><img /><img /></P> Wed, 17 Apr 2019 08:49:46 GMT KBO 2019-04-17T08:49:46Z https://community.fabric.microsoft.com/t5/Report-Server/Weird-Bug-or-nice-feature/m-p/671857#M10087 <P>Hello,</P><P>I build a report based on direct query to a MSSQL DB (SSISDB) in the PBIRS Desktop. Now I have a weird problem If I create a table with some columns and a separate card visual with a distinct count I get a blank (All data is in the same table - no relationships). BUT If I delete the columns with format date (no matter which) the count counts. Is this normal or is it because it's PBIRS :D?</P><P>Best Kathrin</P><P>&nbsp;</P><P>Picture One - without any columns with "date" format</P><P>Picture two - with date columns</P><P><img /><img /></P> Wed, 17 Apr 2019 08:49:46 GMT https://community.fabric.microsoft.com/t5/Report-Server/Weird-Bug-or-nice-feature/m-p/671857#M10087 KBO 2019-04-17T08:49:46Z https://community.fabric.microsoft.com/t5/Report-Server/Weird-Bug-or-nice-feature/m-p/671864#M10088 <P>Problem solved with Datevalue as DAX Calculated Columns - but nice to know that this is another thing that doesn't work in PBIRS Desktop Client in DQ ;)</P> Wed, 17 Apr 2019 08:55:42 GMT https://community.fabric.microsoft.com/t5/Report-Server/Weird-Bug-or-nice-feature/m-p/671864#M10088 KBO 2019-04-17T08:55:42Z