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 count of the source


the actual requirement is :


If the Source filter is not selected, it should show The KPI which I created (source distinct count)
But if the user selects any one source, it should show the source name which the user selected
Output excepting :
Scenario 1: If the source is not filtered(like the above image) the output describing #source 5(Distinct count of all sources)
Scenario 2: If the source is selected (Eg: From source slicer user selected analytics text value) so in that case instead of shoeing distinct count, it should show the selected source name, so here output is 
Analytics(instead of scenario 1 output)


Thanks 
Alan









 



1 Reply

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion

    Hi AlanP514 
    Please use

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