Forum Discussion

v-rouge's avatar
v-rouge
Regular Visitor
6 years ago
Solved

Comparing two columns for Card visual

Hello, I am new to DAX expressions so hoping someone can help.    I have two columns from a SharePoint List source. I want to compare Column 1 to Column 2 if it is equal to, greater than or less th...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    v-rouge Maybe:

     

    Measure 1 = COUNTROWS(FILTER('Table',[Column1]=[Column2]))

Measure 2 = COUNTROWS(FILTER('Table',[Column1]<[Column2]))

Measure 3 = COUNTROWS(FILTER('Table',[Column1]>[Column2]))

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

v-rouge Maybe:

 

Measure 1 = COUNTROWS(FILTER('Table',[Column1]=[Column2]))

Measure 2 = COUNTROWS(FILTER('Table',[Column1]<[Column2]))

Measure 3 = COUNTROWS(FILTER('Table',[Column1]>[Column2]))

 

v-rouge's avatar
v-rouge
Regular Visitor
6 years ago

Genius - that worked. Thanks so much Greg_Deckler! I'll mark it as solved now.