Forum Discussion

Ritesh_Air's avatar
Ritesh_Air
Icon for Post Patron rankPost Patron
3 years ago
Solved

Filter Data based on IF condition - 2 tables

    Hello,   I have a file called SKU guidance which is maintained on SharePoint. I added those Guidance values on Item table by using LOOKUPVALUE.   Guidance = LOOKUPVALUE('SKU Guidance'[Guid...
Need Help
  • parry2k's avatar
    parry2k
    3 years ago

    Ritesh_Air you can add this as a measure:

     

    Guidance Measure = 
IF ( SELECTEDVALUE ( CustomerTable[Customer] ) = "NM", 0, MAX ( ItemTable[Guidance] ) )
parry2k's avatar
parry2k
Icon for Super User rankSuper User
3 years ago

Ritesh_Air you can add this as a measure:

 

Guidance Measure = 
IF ( SELECTEDVALUE ( CustomerTable[Customer] ) = "NM", 0, MAX ( ItemTable[Guidance] ) )