Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Greg_Deckler

 

I am just looking for a simple table which will show two columns and data will change when I apply some filters. 

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Anonymous

 

Try this technique

 

First create a single column calculated table

 

Parameters =
DATATABLE (
    "No of ID2 enabled", INTEGER,
    {
        { 1 },
        { 2 },
        { 3 },
        { 4 },
        { 5 }
    }
)

Now you can write a MEASURE (Assuming TableName is Table1)

 

Count of ID 1 =
VAR temp =
    SUMMARIZE (
        Table1,
        Table1[ID1],
        "Count of ID2", CALCULATE ( COUNT ( Table1[ID2] ), Table1[State] = "Enabled" )
    )
RETURN
    COUNTX (
        FILTER (
            temp,
            [Count of ID2] = SELECTEDVALUE ( Parameters[No of ID2 enabled] )
        ),
        [ID1]
    )

 

 

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Zubair_Muhammad

       

      You have created a table called parameters with values inserted in it manually. But the whole chanllenge with my problem i sto get those numbers populated automatically. I cannot add static column.