Forum Discussion
contains selected value dynamic report
Mareno_123 Here is the fully tested solution:
For this to work, you need a DimColour table that is NOT related to the table. For testing purposes you can create a new TABLE using DAX, but this should ideally be created in M in data model:
DimColour = VALUES(table[colour])
Create a slicer for DimColour[colour]
Create a DAX MEASURE:
CountAllColoursforSelectedColour = IF(HASONEVALUE(DimColour[Colour]),CALCULATE(COUNTROWS(FILTER('table','table'[colour]=SELECTEDVALUE('DimColour'[colour]))),all('Table'[Colour])),COUNTROWS('Table'))Create a matrix using Table[Colour] for columns, Table[ID] for rows and the new measure for values.
i missed one bar after first table and after add it it still wrong 😞
Mareno_123 Here is the fully tested solution:
For this to work, you need a DimColour table that is NOT related to the table. For testing purposes you can create a new TABLE using DAX, but this should ideally be created in M in data model:
DimColour = VALUES(table[colour])
Create a slicer for DimColour[colour]
Create a DAX MEASURE:
Create a matrix using Table[Colour] for columns, Table[ID] for rows and the new measure for values.
thank you so so much