Help with Card Visuals showing (BLANK)

Question

Hello all,&nbsp;I need help with an issue that I am facing.I created measures for:Yearly Gross Revenue,Yearly Net Revenue,Yearly Profit,Yearly Profit Margin,Quarterly Profit,Year-To-Date (YTD) Profit,Median Sales.&nbsp;But the DAX Measures I created are all returning (BLANK) card visuals.&nbsp;Can anyone take a look at the DAX measures and assist me in fixing them to get visuals to return actual figures and not (BLANK)?&nbsp;Report ViewModel ViewCalendarTableSales in USD Table 1Sales in USD Table 2&nbsp;Yearly Gross Revenue = &nbsp;TOTALYTD(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUM(‘Sales in USD’ [Gross Revenue USD]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;‘CalendarTable’ [Date]&nbsp;)&nbsp;&nbsp;&nbsp;Yearly Net&nbsp;Revenue = &nbsp;TOTALYTD(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUM(‘Sales in USD’ [Net Revenue USD]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;‘CalendarTable’ [Date]&nbsp;)&nbsp;&nbsp;&nbsp;Yearly Profit = &nbsp;SUMX(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;‘Sales in USD’,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Net Revenue USD] - [Total Tax USD]&nbsp;)&nbsp;&nbsp;&nbsp;Yearly Profit Margin = &nbsp;DIVIDE(&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;[Yearly Profit],&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;[Yearly Gross Revenue],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;) * 100&nbsp;&nbsp;&nbsp;Quarterly Profit =&nbsp;CALCULATE(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Net Revenue USD],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DATESQTD(‘CalenderTable’ [Date])&nbsp;)&nbsp;&nbsp;&nbsp;YTD Profit = &nbsp;TOTALYTD(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Yearly Profit],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;‘CalendarTable’ [Date]&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;Median Sales =&nbsp;MEDIANX(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;‘Sales in USD’ ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Net Revenue USD]&nbsp;)&nbsp;

muhammad_ahmed · Answer

Hi,why you are using bidirectional in creating your relationship.It should be single direction.

hunti · Answer

Hi&nbsp;Muhammad_Ahmed&nbsp;when I was assigned the task those were the instructions given. I also did question it, but thats how they wanted it.

anonymous · Answer

Hi&nbsp;Hunti&nbsp;Double-check the syntax of your measures. For example, in your Quarterly Profit measure, you have ‘CalenderTable’ instead of ‘CalendarTable’.If your problem has not been solved, can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
Best Regards,
Jayleny
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Help with Card Visuals showing (BLANK)

3 Replies

Related content

Blanks showing in table visual

Card visual showing blank where matrix shows data

Show blank values in Matrix Visual

M Formula - Show 0 instead of (blank)

Replace blank with 0 in matrix visual