Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey All
I do Have a Table contain products, every prodcut go Through 6 stages . every stage is contaning the same drop down list ( not started , on progross, hang, complated)
how to biuld a musrement and become with table showing calculation in every stage and drop down list ?
Thanks
Solved! Go to Solution.
So, @Anonymous
you can, for example create a new calculated dimension table like
dimDropDown =
UNION(
SELECTCOLUMNS(DISTINCT('Table'[Analyses Stage]);"dropDown";[Analyses Stage]);
SELECTCOLUMNS(DISTINCT('Table'[BS Stage]);"dropDown";[BS Stage]);
SELECTCOLUMNS(DISTINCT('Table'[Development Stage]);"dropDown";[Development Stage]);
SELECTCOLUMNS(DISTINCT('Table'[RD Stage]);"dropDown";[RD Stage])
)
then add to this new tables your 6 columns:
AnalysesStageCount = calculate(countrows('Table');'Table'[Analyses Stage]=EARLIER(dimDropDown[dropDown]))
BSStageCount = calculate(countrows('Table');'Table'[BS Stage]=EARLIER(dimDropDown[dropDown]))
and so on..
then just add it to the visual Matrix
do not hesitate to give a kudo to useful posts and mark solutions as solution
This is the Outcom
Hi @Anonymous
Unfortunately it is impossible to give you a correct advice without example of your data model.
But I will try. If you have a simple table like
Product | Stage | Drop-Down |
A | Stage 1 | not started |
A | Stage 1 | on progress |
A | Stage 2 | completed |
B | Stage 2 | not started |
B | Stage 2 | on progress |
C | Stage 3 | completed |
so, there is no some more easy way then to create a Matrix visual,
add Stage field as Columns,
Drop-Down field as Rows,
Product field add as Value, then pres narrow near product and choose count
then go to the Format sectin and disable row subtotals:
do not hesitate to give a kudo to useful posts and mark solutions as solution
Thanks alot @az38 for quick reply ,,,
let mak it more clear, i will present the same table :
Product Type | Product Nam | BS Stage | RD Stage | Analyses Stage | Development Stage | Quarter |
P | moon | in progress | in progress | completed | in progress | Q1 |
S | Car | completed | completed | completed | completed | Q2 |
E | AB | wating | in progress | completed | in progress | Q3 |
P | DC | Hold | completed | in progress | Hold | Q4 |
S | LM | completed | Hold | in progress | in progress | Q5 |
As you see the stages is clumns "BC Stage, RD stage ,,,,," , and every stage there is 3 status " inprogross, Complated, Hold, Waiting".
So we do start by product tyep " As oyu see we do have 3 P,S,E". And product name then stages for every product
So, @Anonymous
you can, for example create a new calculated dimension table like
dimDropDown =
UNION(
SELECTCOLUMNS(DISTINCT('Table'[Analyses Stage]);"dropDown";[Analyses Stage]);
SELECTCOLUMNS(DISTINCT('Table'[BS Stage]);"dropDown";[BS Stage]);
SELECTCOLUMNS(DISTINCT('Table'[Development Stage]);"dropDown";[Development Stage]);
SELECTCOLUMNS(DISTINCT('Table'[RD Stage]);"dropDown";[RD Stage])
)
then add to this new tables your 6 columns:
AnalysesStageCount = calculate(countrows('Table');'Table'[Analyses Stage]=EARLIER(dimDropDown[dropDown]))
BSStageCount = calculate(countrows('Table');'Table'[BS Stage]=EARLIER(dimDropDown[dropDown]))
and so on..
then just add it to the visual Matrix
do not hesitate to give a kudo to useful posts and mark solutions as solution
@az38 am trying to implement your soliton and stoped here showing Error
SELECTCOLUMNS(DISTINCT('BS Road Map'[BC]);"dropDown";[BC]);
what you mean by "dropDown"
The error massage : [unexcpected exepression]
Hi @Anonymous
Do you try to add column or measure? Need a column. Do you try to add it to new table?
now its wokring and getting numbers ,
The calcualte CountROWS I need to find somthing deffrant than the ROWs
i have only 72 Rows and the calculated is returing 400 ,,
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
55 | |
35 | |
21 | |
18 | |
15 |