Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Card Visualization don't work with Measure as a Filter

Hello community,   I am very new to PowerBI. I am trying to display the unique record for the Address field that has more than 1 ID for the Card Visualization (or any big number display) on PowerBI...
Need Help
Tips and Tricks
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You can use a measure like this for your card visual.  Replace Table with your actual table name.

     

    Companies with Multiple IDs =
    COUNTROWS (
        FILTER (
            VALUES ( Table[Company] ),
            CALCULATE (
                DISTINCTCOUNT ( Table[ID] )
            ) > 1
        )
    )

     

    Regards,

    Pat

AmandeepThind's avatar
AmandeepThind
New Member
1 year ago

mahoneypat : I am in a similar situation.

I have a new table "SourceTable" having 2 values "Ext" and "Int". I have created a slicer with this table.

Now I have used a card visual and it is displaying values from already created 2 measures.

After this, I have created a new measure as :

IsExternalMeasure = if(SELECTEDVALUE(SourceTable[Source])="Ext",1,0)
 
When I am trying to use above measure as a filter criteria for the card visual, the filter gets disabled.
Please suggest what is going wrong here?
NOTE: The important thing is - I want to display the value in the card , which is getting calculated via measure.