Forum Discussion

Archiv_Internet's avatar
Archiv_Internet
Frequent Visitor
3 years ago

Need Help with Dax

Hi,          I have a table as below sample, I would like to get or count the Order Numbers ( the highlighted ones) were only Product A AND Product B have values in them and I would like to ignore t...
daXtreme's avatar
daXtreme
Icon for Solution Sage rankSolution Sage
3 years ago
[measure] =
CALCULATE(
    COUNTROWS( T ), // T - your table
    KEEPFILTERS( NOT( ISBLANK( T[Product A] ) ) ), 
    KEEPFILTERS( NOT( ISBLANK( T[Product B] ) ) )
)