Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a table which has A, B, C, D, E, F columns and i have created a table view in power Bi and added some slicers to the dashoboard. So now if someone filter the A column slicers and select only one number and data has only one row for it means my table should not display anything. below i have provided the screenshot(if if filter A as 1,2,4,6,7 those data row should not display in my table view and if i filter A as 3 then it should display all those data rows in the table view). I have tired the count based on A and B it didn't work. Any one can help me on this?
Solved! Go to Solution.
Hi @rama211976 ,
I created a sample pbix file(see the attachment), please check if that is what you want.
1. Create a dimension table as below
A = VALUES('Table'[A])
2. Create a measure as below to get it:
Flag =
VAR _selas =
ALLSELECTED ( 'A'[A] )
VAR _taba =
SELECTEDVALUE ( 'Table'[A] )
VAR _counta =
CALCULATE (
COUNT ( 'Table'[A] ),
FILTER ( ALLSELECTED ( 'Table' ), 'Table'[A] = _taba )
)
RETURN
IF ( _counta = 1, 0, IF ( _taba IN _selas, 1, 0 ) )
If the above one can't help you get the desired result, please provide more raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Hi @rama211976 ,
I created a sample pbix file(see the attachment), please check if that is what you want.
1. Create a dimension table as below
A = VALUES('Table'[A])
2. Create a measure as below to get it:
Flag =
VAR _selas =
ALLSELECTED ( 'A'[A] )
VAR _taba =
SELECTEDVALUE ( 'Table'[A] )
VAR _counta =
CALCULATE (
COUNT ( 'Table'[A] ),
FILTER ( ALLSELECTED ( 'Table' ), 'Table'[A] = _taba )
)
RETURN
IF ( _counta = 1, 0, IF ( _taba IN _selas, 1, 0 ) )
If the above one can't help you get the desired result, please provide more raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
@Nalini , If you create a slicer on column A, it should filter whatever is selected in the slicer.
Not very clear, what is not working for you.
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |