Help with Card Visuals showing (BLANK)

[Hunti]

Hello all,

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.

But the DAX Measures I created are all returning (BLANK) card visuals.

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)?

Report ViewModel ViewCalendarTableSales in USD Table 1Sales in USD Table 2

Yearly Gross Revenue =  

TOTALYTD( 

          SUM(‘Sales in USD’ [Gross Revenue USD]), 

          ‘CalendarTable’ [Date] 

) 

Yearly Net Revenue =  

TOTALYTD( 

          SUM(‘Sales in USD’ [Net Revenue USD]), 

          ‘CalendarTable’ [Date] 

) 

Yearly Profit =  

SUMX( 

            ‘Sales in USD’, 

            [Net Revenue USD] - [Total Tax USD] 

) 

Yearly Profit Margin =  

DIVIDE( 

      [Yearly Profit], 

     [Yearly Gross Revenue], 

     0 

) * 100 

Quarterly Profit = 

CALCULATE( 

           [Net Revenue USD], 

           DATESQTD(‘CalenderTable’ [Date]) 

) 

YTD Profit =  

TOTALYTD( 

          [Yearly Profit], 

          ‘CalendarTable’ [Date] 

)  

Median Sales = 

MEDIANX( 

          ‘Sales in USD’ , 

          [Net Revenue USD] 

) 

[Anonymous]

Hi @Hunti 

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.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Muhammad_Ahmed]

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

[Hunti]

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