How to get aggregated value if no value selected from slicer

[harib]

Hello Friends

How to get aggregated value if no value selected from slicer. I want the output like below image. In slicer there are 3 values. if i dont select value from slicer output should com like Mark 2. I mean aggregated value show come.If  it's possible kindly describe how to achive .

Thanks

[DouweMeer]

What you have to do is create a measure as you request a different scalar value based on a change in context in the dashboard.

What you can do is create another table with you column values. Then use it as a filter in your dashboard. Following is adding a measure with:

if ( hasonevalue ( new table ) , "column" , "Mark2" )

It roughly works on the same principe as a dynamic axis. 

https://www.youtube.com/watch?v=n-OWNaCUU0o

[harib]

@DouweMeer 

Why rows are incresing when we go for unpivot as i shown in the picture. In the real time senario if we have 1,00,000 rows and when we go for unpivot based on the unpivot column values it's multiplying the rows . Then we may get performance issue right

ex : In my picture before unpivot table has 4 rows and when i unpivot 3 columns these 4 rows are increased upto 12 rows becasue of 3 columns like (Column A, Column B, Column C ). 

Can anyone clarify on this

Thanks

[DouweMeer]

Well, that is how an unpivot works. If you unpivot them all at once, you get 1 column stuffing all data in separate rows. 3 columns x 4 rows becomes 1 column x 12 rows.

Else you would loose data.

But I've done that with my dataset as well. Just have 2 tables instead and tie them to a unique key in the main table. 1 new table that is unpivotted with no extra information and the other tables, the main table, with all additional information. This way you don't duplicate unnecessary.

[harib]

@DouweMeer 

That's fine ,i also did the samething, but i want to get the aggregated value when we dont select any values from the slicer.Is it possible. 

Thanks 

[DouweMeer · Accepted solution]

I would say based on your explanation that you could tackle is by using an if statement in the measure, like mentioned before.