Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
KalvisTete
New Member

Return all names as rows in a table visual for selected value in bar chart

Hi.

I have this visual that is created by a dax. 
DAX CODE:

Active =
VAR _Hr = SELECTEDVALUE('Hours'[Hour])
VAR _Logic =
CALCULATE(
COUNTROWS(MainTable),
FILTER(MainTable,MainTable[Start] <= _Hr
&& MainTable[End] >= _Hr
)
)
RETURN _Logic
 
VisualKalvisTete_0-1696423492595.png

The measure counts how many processes are running at the same time for given time. 

How can I get a table of all the names of processes that are running for the selected value?

I don't have a relationship between tables, but if I add it, then it doesn't count it correctly anymore.

These are my tables,

MainTable

KalvisTete_1-1696423908218.png

 

 And Hour Table

KalvisTete_2-1696423928098.png

Any help is appreciated. Thanks!

1 REPLY 1
lbendlin
Super User
Super User

instead of COUNTROWS() you use CONCATENATEX().

 

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.