DAX-Based on slicer selection values show related column(Dimension and Measure Tables)

[udhayakumarr28]

Hi Experts ,

consider below table is my source .

ProductID	Product	Category	Subcategory	Quantity	UnitPrice	Amount
1	AAA	C1	SC1	10	2	20
2	BBB	C2	SC2	5	5	25
3	CCC	C3	SC3	15	4	60
4	DDD	C4	SC4	20	5	100

 I created the Dimension and Measure table.

Dimension table Values consist ProductID,Product,Category,SubCategory.

    Values

ProductID

Product

Category

SubCategory

Measure table Values consist of Quantity, UnitPrice, Amount.

    Values

Quantity

UnitPrice

Amount

Here I'm using slicer in Dimension[values] & Measure[values] .

Example:

1.if I select Product in Dimension[values], Table visual will show

Result:

Product

AAA

BBB

CCC

DDD

2.if I select Product in Dimension[values] and Quantity in Measure[values].Table visual will show

Product	Quantity
AAA	10
BBB	5
CCC	15
DDD	20

3.If no values selected in Dimension[values] and Measure[values] 

Table will show Text( select any Dimension )

4.If only values selected in Measure[values] that time also

Table will show Text( select any Dimension )

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

All measures are in the attached pbix file.

One way to solve it is to transform the source table like the one below.