Forum Discussion
Output Status as Column
- 7 years ago
hi, Anonymous
You may try this way:
Step1:
Create a Cstatus Dim table(Do not create a relationship with basic table).
Step2:
Then use this formula add a new measure
Measure 2 = IF(SELECTEDVALUE(Dim[Cstatus])=[Measure],COUNTA('Table'[Name]))Step3:
Drag Cstatus field from Dim table and measure 2 into a pie chart.
Result:
here is new sample pbix file, please try it.
Best Regards,
Lin
- 7 years ago
hi, Anonymous
If so, try these two measure:
Measure = CALCULATE(IF ( DIVIDE ( CALCULATE ( SUM ( 'Table'[Billing Hours] ) ), CALCULATE ( SUM ( 'Table'[HoursForWeek] ) ) ) < 1, "PB", "Billable" ),FILTER(ALLSELECTED('Table'),'Table'[Name]=SELECTEDVALUE('Table'[Name])))Measure 2 = VAR _table=SUMMARIZE('Table','Table'[Name],"_discount",[Measure]) var _table2=FILTER(GENERATE(_table,Dim),[Cstatus]=[_discount]) return COUNTAX(_table2,[Name])If you still have the problem, please share your sample pbix file.
Best Regards,
Lin
Hi @v-lili6-msft ,
Based on your suggesstion, i achieved the scenario but
i have the problem in association.
if i click the chart1, chart2 could not be associated.
Any help would be appreciated
Thanks in advance
Prakash
Hi v-lili6-msft ,
Just rephrasing the below content.
Earlier we created "Billing Status" Pie chart based on "Billing Hours" column.
Now i have created "Utilization Status" Pie Chart based on "Utilization hours" column. (Similar technique followed i.e., same as Billing Status pie chart )
Now the problem when i select any of these Pie chart then the oter Pie chart is not getting associated based on selection.
Provided the Power BI File.
Regards,
Prakash
- v-lili6-msft7 years agoCommunity Support
hi, Anonymous
There are two mistakes in your report:
1. For Dim1 Utilizationstatus, It is "Partiallyutilized" and "Fullyutilized", but in your formula is "Partially utilized" and "Fully utilized", they couldn't match.
2. In UtilisationOutput measure, " Dim1=[Utilizationstatus] " is wrong.
It should be like this:
[Utilizationstatus]=[_utilize]Best Regards,
Lin
- Anonymous7 years agoNot applicable
As per your comments i updated the dax query, still the chart could not be associated.
Prvided the Pbix file.
https://avacorp1-my.sharepoint.com/:u:/g/personal/yuvaraj_g_avasoft_com/EVTM05iN7CJCp7MW1SNygu0BkOtqEDUbbnedNN_IGk7leQ?e=rsKFHh