Forum Discussion

AlanP514's avatar
AlanP514
Icon for Post Patron rankPost Patron
4 years ago
Solved

KPI -Dax

Hi team,  I need your help to achieve this task: Requirement: I have one slicer called source(Which contains different sources and type is text) Based on that source I created one KPI, a Distinct...
Need Help
Show and Tell
Tips and Tricks
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi AlanP514 
    Please use

    SELECTEDVALUE ( 'Table'[Source], DISTINCTCOUNT ( 'Table'[Source] ) )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi AlanP514 
Please use

SELECTEDVALUE ( 'Table'[Source], DISTINCTCOUNT ( 'Table'[Source] ) )