Forum Discussion
Creating two tables from one data table which has totals
Looking for help creating a display using DAX. I have a semantic model which pushes data (totals and components in one table) to Power BI (can't create relationships in Power BI). What I would like t...
hello Anonymous
please check if this accomodate your need.
1. create a new measure for calculating 'Counting' value
CountValue = CALCULATE(SUM('Table'[Count]),'Table'[Owner]<>BLANK())
2. plot the measure and column in table visual for first table3. create another table visual for second table. use visual filter to remove empty value in 'Owner' column.
Hope this will help.
Thank you.
Irwan
Super User
Super Userhello Anonymous
please check if this accomodate your need.
1. create a new measure for calculating 'Counting' value
CountValue = CALCULATE(SUM('Table'[Count]),'Table'[Owner]<>BLANK())
2. plot the measure and column in table visual for first table
3. create another table visual for second table. use visual filter to remove empty value in 'Owner' column.
Hope this will help.
Thank you.