Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Error using measure with scorecard

Hello all,

 

I am using a mesaure with the DAX formula- CALCULATE(COUNTA(Table 1[SalesNo]),DATESMTD(Date Table[Date1])) for Mesaure A and CALCULATE(COUNTA(Table 1[SalesNo]),DATESMTD(Date Table[Date2])) for Measure B. Both these mesaures are being used in a card visualization and hence I dont have any date slicers. Mesaure A is displaying accurate results even without date slicer. But Mesaure B will show Blank if no date slicer is used. I cant have a date slicer there as per requirements. What should I do?

 

Thanks in advance.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Got a solution to this. Had to set the relationship Cardinality to Both. Works fine now!

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Got a solution to this. Had to set the relationship Cardinality to Both. Works fine now!

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.